FRM-40202 Field must be entered

From: <gpopa_at_my-dejanews.com>
Date: Wed, 05 Aug 1998 16:54:47 GMT
Message-ID: <6qa2on$c45$1@nnrp1.dejanews.com>

My form is not working quite right due to the FRM-40202 error when then user tries to query or delete a record that has cascading properties to other blocks. After an attempt to delete the record, the cursor jumps to the child record or to the same block inside a required field.

What I have been doing is testing for the form mode of operation before assigning any value to a field, as this should be prevented when the user is in query mode or enter-query mode.

I have been partially successful using the following tests...

IF :SYSTEM.FORM_STATUS <> 'QUERY' THEN ...

and

IF :SYSTEM.MODE <> IN ('QUERY', 'ENTER-QUERY') THEN ...

I'm using Forms 4.5 version 4.5.7.2.1 and DB server 7.3.3.4.0. Any suggestions?

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Aug 05 1998 - 11:54:47 CDT