Re: Need HELP !! SELECT A RECORD BY QUERY BUT POSSIBILITY TO NAVIGATE ????

When I have 10000 records and use GO_RECORD (rownum).. it's very slow.. so I suppose it validate every record when navigating to the good rownum record. (I repeat, I want to go directly to the good record, but I want to have all records accessible by next and previous button)

How to go directly to the good record (to show on the Form screen) without using the GO_RECORD and without making a LOOP and compare datas in every records.

Imagine this for a 10000 records in a block ...

Thanks for any advices-

Olivier Régis
MCSE+I, OCP Andy Hardy <aph_at_ahardy.demon.co.uk> wrote in message news:DeQyFDAREf63EwFU_at_ahardy.demon.co.uk...
> In article <7scnn3$ro9$1_at_news.worldcom.ch>, Olivier Régis
> <olivier.regis_at_duroblade.com> writes
> >btw I don't want to use the GO_RECORD because it's too long (validate
each
> >records between)..
>
> That's a shame - I was about to suggest that (I keep track of records by
> date on a post-query, populate a global and then use that value after
> the execute_query)! Are you sure that there is long validation for
> unchanged records?
>
> Andy
> >
> >Olivier Régis <olivier.regis_at_duroblade.com> wrote in message
> >news:7scnc3$rnq$1_at_news.worldcom.ch...
> >> I have problem to resolve on Forms 6.0:
> >> ================================
> >>
> >> I want to be able to have query of all record (this is not a problem),
> >just
> >> need "execute_query"..
> >> Then I want to go directly to a specified record by using "where
clause"
> >..
> >> without disabling navigation to the other records.
> >>
> >> Actually, I modify the where clause in the block property, or use the
> >> Pre-Query trigger.. but the problem is I have only one record selection
> >and
> >> I cannot navigate in the other records by using "next-record",
> >> "previous_record"...
> >>
> >> Any advices from a specialist are welcome
> >>
> >> Olivier Régis
> >> MCSE+I, OCP ADM
> >> Switzerland
> >> olivier.regis_at_duroblade.com
> >>
> >>
> >>
> >>
> >>
> >
> >
>
> --
> Andy Hardy. PGP key available on request
> ===============================================================
Received on Fri Sep 24 1999 - 09:07:41 CEST