Re: Sorting with Forms 5.0

[Quoted] Hi Serdar,

we had the same problem and found a good solution that is not too complicated.

Do not use the post-query trigger to query the lookup-items. Instead use a view and use the view as datasource. Then you do not have to worry about the post-query-trigger. You have to set the property "query only=yes" for the lookup-items. They will be excluded in insert- und update-statements.

Then we've put the option "Sort" in the context-menu of the right mouse button. A trigger changes the sort-clause and is executing a requery.

roland
Roland Schaar
Gosch Consulting GmbH

Serdar Yorgancigil wrote:

> Hi everyone,
>
> I have multirow database block and some queried data in it. I want to
> sort the block without executing the query again. And the block has to
> be sorted according to the users choice.
>
> I think pl/sql table can be used. But I wonder if anybody has a better
> suggestion.
>
> Thanks in advance...
Received on Wed Jul 28 1999 - 10:52:42 CEST