Re: Forms, CGen45 & LOVs

We usually make the field not required and do not fire the validate trigger if the filed is null.

To make sure all the mandatory fields are entered, the pre-insert/pre-update triggers on the block are added with appropriate messages. The also helps us by not showing ORA related error messages to the users directly.

HTH Prasad Chavali

Davis Kulis <davis_at_itsystems.lv> wrote in article <34E72DB9.F65EEB1F_at_itsystems.lv>...
> Hi there!
>
> I have the following problem:
>
> I generate LOV with button just beside field. Column to be filled
> is mandatory. Everythin is ok except when I enter the field and
> try to press the LOV button I get validation message that field
> value is wrong even when field is EMPTY! (optimaly it should
> work even with wrong values, but for the begginning I just want
> to set the empty fields)
>
> TIA
> Davis
>
> P.S. please email your suggestion directly to me as well
>
  Received on Mon Feb 16 1998 - 00:00:00 CET