Re: Sorting with Forms 5.0

Hi Roland,

Thanks for the help but there may be thousands of records in the block and I don't want to requery, because I have to use the "Query all records = yes" option due to user demands.

What I am looking for is a method which takes the records from block, sorts it and writes them back to the block.

Roland Schaar wrote:

> 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 - 13:04:31 CEST