Re: Forms 4.5 Control item update HELP!!!!!!

>Forms automatically recognizes when a control item changes, setting the
>record/block status to changed, hence the need to set the record status
>back to 'QUERY' when populating control items in a Post-Query trigger.
>A When-Validate-Item will detect the item has changed.

[Quoted] Forms DOES NOT recognize a CONTROL item has changed.

>If the control item belongs to a table you want to....

By definition a control item does not belong to a table.

You are confusing a control item with a foreign key lookup item. In this case a change is recognized because your when_validate_item trigger is changing the associated base table item.

> hence the need to set the record status
>back to 'QUERY' when populating control items in a Post-Query trigger.

If you are doing this then you have multiple, unneccessary calls to the database. Your post_query trigger has just retrieved the lookup value, so why do it again? . (unless of course your referential integrity is shot to hell). If your block has multiple lookups the overhead is horrifying.

Rather, wrap yourvalidations in an IF construct.to prevent [Quoted] validation during query.

  IF :system.mode <> 'QUERY' THEN

• do the validation END IF;