Re: How to save the query from the form and re-use it later?

john_at_timer1.UUCP (john) writes:

>Hello, World:
 

>We are implementing a form to access customer database. So, it is kind of
>basic like name, address, phone numbers and titles etc.
 

>Oracle Sql*Form 3.0 provides query by form (kind of nice). We would like to
>use this feature but we also want to save the query for future use because
>some queries can be so complicated and our users don't want to re-type it
>over and over again. In addition to that, we also like to dump the results
>not only on the screen but also into a file so we can use it with mail
>merger of word processor.
 

>Is there any one out there who can give us a little guide, instruction or
>pointer on how to implement this mechanism ?
 

>Any help will be highly appreciated.

>John Y. Chan

Try using the :SYSTEM.LAST_QUERY value. You can do a variety of things with it and the HOST procedure. Hope this helps; -Greg Received on Wed Jan 13 1993 - 22:30:53 CET