DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Prevent from leaving TEXT_ITEM - Forms6i

  1. #1
    Join Date
    Nov 2007
    Posts
    1

    Prevent from leaving TEXT_ITEM - Forms6i

    Hi everybody!

    I have a question how to prevent from leaving TEXT_ITEM when for example inputed value is incorrect or is null. Wat trigger should I use? I tried POST-TEXT-ITEM, I can warn user that empty values are not permitted, but anyway cursor goes to next item...

    Any help appreciated Smile

    Thanks
    Tom

  2. #2
    Join Date
    Sep 2000
    Location
    Sao Paulo,SP,Brazil, Earth, Milky Way
    Posts
    350
    very very easy : in your post-text-item trigger, add a call to the RAISE_FORM_TRIGGER_FAILURE, it results in an abort of the normal flow, in your case aborting the exit from the text item.... Check the Forms help, you will find many refs and some examples.

    []s

    Chiappa

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