Pre-insert validation : go-item not allowed, how to focus on missing item?
660131Sep 16 2009 — edited Sep 16 2009Forms [32 Bit] Version 10.1.2.2.0 (Production)
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
Hi,
I have what seems like a simple problem, but I don't know how to get around it.
Basically, before I allow a user to save a record on the form, I want to do a check to see that all values that can't be null are entered. If I set the fields to required, they have to be entered, but the default message isn't very descriptive in saying what is missing. If I do a check in a pre-insert trigger, I can display an alert if the value is null and raise a form trigger failure, but I am not allowed to use a go_item in the pre-insert trigger.
Is there another way I can do this?