Re: Re - Executing the last user defined query in a form?

reichmanm_at_removethis.rl.af.mil. (Mark S. Reichman) wrote:

>How would a programmer re-execute the last query performed
>in a SQL 3.0 form by a user with code. I know if you
>press the keys.. [Enter Query] [Enter Query] [Execute Query] in
>a form the last user defined query will re-execute. However,
>when the previous is put into a trigger it hangs on the first
>[Enter Query] waiting for the user to type something into a field..
>
>Sooo... Any solid Ideas would win you a cookie.. Thanks...
>

The last query executed by an Oracle Form is stored in a variable named :system.last_query

• so you could use this to 'feed' an execute query trigger.....

Hope it helps, Received on Tue Jul 14 1998 - 09:35:26 CDT