When-Validate-Item trigger

[bengal_joe]

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

[Sameer]

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..

nLen := LENGTH(field_contents);
IF nLen <= 1 THEN
   message ("bla bla..");
END IF;

write a compatible code in trigger body or whereever u need..

[stecal]

< 2 will suffice.