Home » Developer & Programmer » Forms » Field Input Validation to Check User Inputs (Trigger)
Field Input Validation to Check User Inputs [message #413949] Sun, 19 July 2009 10:47 Go to next message
Only-Oracle
Messages: 43
Registered: June 2009
Member
hi everybody

I'm facing a problem. I'm creating a form and there is a field in the form I want to make a restriction on the field so the user can't enter less than 4 characters and it also if it's possible to have restriction not entering more than 16 characters. So which trigger shall I use for. Please help me

I did here a code but it's not working with me:

IF :PASSWORD1 < 4 THEN
message('Password should be at least 6 character.');
display_error;
raise form_trigger_failure;

ELSIF :PASSWORD1> 16 THEN
message('ERROR: Password should not exceed more than 16 character.');

display_error;
raise form_trigger_failure;
END IF;
Re: Field Input Validation to Check User Inputs [message #413957 is a reply to message #413949] Sun, 19 July 2009 14:25 Go to previous message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
WHEN-VALIDATE-ITEM trigger is the trigger. You need to use the LENGTH function against item's value, not the value itself.
Previous Topic: Unable to locate record in Block
Next Topic: how can we create Menus?
Goto Forum:
  


Current Time: Sat Dec 03 08:20:02 CST 2016

Total time taken to generate the page: 0.07613 seconds