When-Validate-Item trigger
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: When-Validate-Item trigger

  1. #1
    Join Date
    Jan 2003
    Posts
    2

    When-Validate-Item trigger

    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

  2. #2
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588
    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..

    Code:
    nLen := LENGTH(field_contents);
    IF nLen <= 1 THEN
       message ("bla bla..");
    END IF;
    write a compatible code in trigger body or whereever u need..

  3. #3
    Join Date
    May 2002
    Posts
    2,645
    < 2 will suffice.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width