Ya know.. I read about :system.last_query.. Problem with that is it
contains the entire select statement(Select,Into,From,Where).. So then, I
figured I could somehow substring out the where clause of :system.last_query..
Question is , how do I get this substringed where clause into the "default
where" clause of the form so that when I issue the command "Execute Query" it
uses this new default where clause.. Note: The form will not accept a Global
Variable in the default where clause.. This would become something of a
"dynamic default where clause" (<-- Hrmmm..) from user query to user query...
Thanks -Mark
In article <35ab6c23.2981156_at_news2.mm.com>, johng_at_mm.com says...
>
>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 - 11:37:48 CDT
