Re: Getting the first row from a select
From: DET <none_at_i_hate_spammers.com>
Date: 1998/10/07
Message-ID: <6vg0hh$pcp_at_netaxs.com>#1/1
Date: 1998/10/07
Message-ID: <6vg0hh$pcp_at_netaxs.com>#1/1
>>'check you found one
>>if not rec.nomatch then
>> 'BINGO, YOU HAVE THE FIRST ONE AND YOU DID NOT BROWSE THE HUGE
TABLE...
>>endif
>
>
>I am not a VB DAO expert but...I thought the DAO .seek function performed a
>full table search. I believe this would involving reading all of the
>records into the client to scan for the 'WhateverWasEntered' this could
>potentially take a long very long time.
>
It does. And it does. My original post specified that the file is BIG and this solution would not be acceptable. I have to be able to filter the dynaset down to 1 record *before* it gets transmitted across the network. Received on Wed Oct 07 1998 - 00:00:00 CEST