Re: Forms 3.0 question

>I have a block containing 1 queryable field and several display-only
>fields. When I SELECT info from a table into these fields, every thing
>is OK except when I try to clear or leave the form. The question, "Do
>you want to commit changes??" pops up. However, if I instead perform
>the following commands:
> go_block('block_name'); execute_query;
>
>I do NOT get the "commit" prompt when leaving the form. Why is there
>a difference between these 2 actions?

When you _select_ into a field the system.record_status on the block is 'NEW' -- oracle thinks that you are selecting info into a new record (the same as if you were creating a new record).

When you do an execute_query to insert the data, oracle knows that this is an existing record, and the system.record_status is 'QUERY'.

>How can I prevent the "commit" prompt from popping up when all that was
>done was a "query"??

There are a few solutions -- Why not go with the execute_querry option.

Marcus Anthony
Dept of Public Safety
Santa Fe, NM Received on Tue Dec 20 1994 - 17:08:57 CET