Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Need HELP !! SELECT A RECORD BY QUERY BUT POSSIBILITY TO NAVIGATE ????

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

From: Andy Hardy <aph_at_ahardy.demon.co.uk>
Date: Thu, 23 Sep 1999 10:21:21 +0100
Message-ID: <DeQyFDAREf63EwFU@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 Thu Sep 23 1999 - 04:21:21 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US