Re: Sorting
From: Frank <frankbo_at_interaccess.nl>
Date: Wed, 11 Oct 2000 12:03:16 +0200
Message-ID: <8s1dt7$lo6$1_at_porthos.nl.uu.net>
Date: Wed, 11 Oct 2000 12:03:16 +0200
Message-ID: <8s1dt7$lo6$1_at_porthos.nl.uu.net>
[Quoted] Like storing the rowid?
-- Frank Andrew Hardy <Andrew.Hardy_at_BGTechnology.com> schreef in berichtnieuws 8s16rk$j54$1_at_sun-cc204.lboro.ac.uk...Received on Wed Oct 11 2000 - 12:03:16 CEST
> Perhaps you could 'recognize' the record you were on during the POST-QUERY
> and then use GO_RECORD to move directly to it?
>
> Andy
> <lopezrichie_at_my-deja.com> wrote in message
> news:8rt5at$eu9$1_at_nnrp1.deja.com...
> > We are trying to make a sort order functionality in our forms. For
example ;
> > when a user is on a certain record and he/she wants to order by another
> > field, he/she presses this sort order button. The code behind the button
sets
> > the block property order_by to order by the other field. Then it
executes
> > query( as you know the new sort order does not work until you execute
query).
> > Then it loops so it can fall on the same record it was on. This works
but on
> > a table with 32000 records, it runs pretty slow. Does anybody have any
ideas?
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>