Hi there
I am trying to put a WHEN-VALIDATE-ITEM trigger on my form to ensure users enter more than 1 character for a persons Initials. Could anyone give me some advice on the SQL syntax for this please.
Many thanks
Joe
Printable View
Hi there
I am trying to put a WHEN-VALIDATE-ITEM trigger on my form to ensure users enter more than 1 character for a persons Initials. Could anyone give me some advice on the SQL syntax for this please.
Many thanks
Joe
Well, I have never used FORMS, but you just need a simple logic,
When length of the contents of field is <= 1 character, throw an error message..
write a compatible code in trigger body or whereever u need..Code:nLen := LENGTH(field_contents);
IF nLen <= 1 THEN
message ("bla bla..");
END IF;
< 2 will suffice.