Field validation in a Queried record (SQL*Forms)

Hi,

        Once again I need to turn to the expert knowledge of the net for help. I have a form which is used in to ways. The first is as straight data entry. To go with this there are various attributes attached to the fields (e.g.  Mandatory, Uppercase) and also some POST-CHANGE triggers to fill in some other fields (and validate the data too.) There a also a few key triggers. All but a few of the keys have been disabled. The rest have normal operation, except KEY-COMMIT which commits and then exits (so only one record can be entered at a time)

        This all works fine, until the form is used in its other mode. Instead of entering a new record, the operator can query an existing (half-completed) one Since all the fields are Update If Null, they cannot cahnge the data already entered, but they can fill in the blanks. My problem is that SQL*Forms doesn't _force_ them to. They can fill in just one field and commit that to the database. The normal checks of Mandatory etc. aren't being applied to the fields the operator never enters.

  First question: WHY is this happening ???

  Second Question: What can I do about it ?

All ideas,theories,solutions etc. gratefully recieved. E-mail preffered, but not essential.

        Thanks,

                        David McCann Received on Thu Jul 22 1993 - 14:31:45 CEST