Re: Built-in Restricted Packages in forms 4.5

From: Francisco Piragibe <piragibe_at_iis.com.br>
Date: 1995/10/01
Message-ID: <44mbdk$2h5_at_news.iis.com.br>#1/1


sorry for the clipped response...

ORACLE FORMS does not allow you to leave an invalid field. So, in order to do what you want, you can try this workaround:

  1. Instead of invalidating the field, set the value of an invisible field to, let's say, 'Y' if the field is valid and 'N' if it's invalid. Initialize this second field to 'Y' in the beginning of the ON/WHEN VALIDATE trigger.
  2. Build a KEY-OTHERS trigger on that field that interprets the hidden field and switch either to the previous block you mentioned or to the next field, depending on the value of the hidden field. This works fine for FORMS 3.0. In FORMS 4.X, you should also take care of the mouse events, forbidding mouse navigation when the cursor is in that field.

Maybe it's a good idea rethinking your design, 'cause the workaround is quite complicated... Received on Sun Oct 01 1995 - 00:00:00 CET

Original text of this message