Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2004
    Location
    Oklahoma City OK -
    Posts
    122

    Unanswered: Using Form Personalization and testing for Insert mode

    TRIGGER_EVENT = WHEN-VALIDATE-RECORD

    How do I write an oracle form personalization 'condition' that will evaluate true only when a record is a new insert like:

    CONDITION:

    record is an insert and
    :USER.NAME IS NOT NULL AND
    :USER.EMAIL_ADDRESS IS NULL

    I have tried selecting different TRIGGER_EVENT such as WHEN-NEW-RECORD, still no success

    SOLUTION FOUND.
    Last edited by wrwelden; 10-30-07 at 12:27.

  2. #2
    Join Date
    Oct 2004
    Location
    Oklahoma City OK -
    Posts
    122
    Pardon the post. It has been a while since I have dealt with forms.

    The solution is:

    YSTEM.RECORD_STATUS IN ('NEW','INSERT') AND
    :USER.USER_NAME IS NOT NULL AND
    :USER.EMAIL_ADDRESS IS NULL

Posting Permissions

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