Re: Help on Using ORACLE forms 4.0

You can fire unrestricted built-in routines from key-nxtfld. These are not legal in when-validate-item. So perhaps just moving your logic to key-nxtfld would work (you would need to trap other logical key triggers as well e.g. key-prvfld).

Alternatively, you could perhaps make your header block a non-database block. A 'New' or 'Insert' button could also do the trick.

In article <30j0st$95o_at_hk.super.net> hdrjoe_at_hk.super.net "Mr Joseph Ho" writes:

: What we have are a base table block (eg. Voucher hearder record)
:and a detail base block (with item details belonging to the above voucher).
: When we enter an existing voucher number in the base table block, it
:displays all the item details in the detail block. This is fine, but what we
:also want to do is this...
: After we typed over this voucher number with a new number (not yet
:in the database) we want Oracle to 'automatically' clear the detail
:block and let us start creating a new voucher with new items.
:'Automatically' means without pressing any other keys.
:My programmer has a problem doing this. I was told it was because in
:WHEN_VALIDATE_ITEM one cannot clear blocks and also cannot go into
:insert mode. Any suggestions on how we can implement this style
:of user interface in Oracle Form 4.0?
 

-- 
Glenn Nicholas, Concept             |   Internet: Glenn_at_wplace.demon.co.uk