Re: Oracle Forms -- special query???

When in query mode, enter a value of '&p' (withouth the quotes) into one of your query fields. When you press 'Execute Query' you will get a pop-up box appear. Into this you can type any extra AND clauses you wish (exclusing the first AND keyword though) so you could enter

My_PK_Field > 'This value'

and when you press execute query it is added to the default where clause (effectively).

Of course, this technique relies on you knowng the column names of the underlying table as you are, basically, entering raw SQL within your form at runtime.

Hope this what you're after.

--
Alan D. Mills

>
>I've got a form with multiple fields (one row per page); users need to be
able
>to search for records to update. Currently they can simply execute a query
>(button bound to 'execute_query') and retrieve all the rows, or enter some
>criteria and retrieve rows matching those crieteria.
>
>The user wants to be able to enter a primary key and do one of two things,
>either navigate forward and backward (ie, retrieves all rows, but starts at
>the one they entered), or be able to navigate forward from that pk onle
>(starts on their entered pk, retrieves where pk > entered_pk).
>
>Is there a good way to do this??? How?
>
Received on Fri Jul 31 1998 - 06:36:37 CDT