Re: Getting the first row from a select

>Maybe I'm missing something obvious....
>
>I'm trying to write a VB program that will get the first record from a
 query
>something like:
>
>select * from COMPANY where COMPANY_NAME >= 'whatever was entered';
>

Using the dbOpenForwardOnly type of recordset may eliminate the cost of doing the simple query and only using the first retrieved column.

Under certain conditions you can get the first row by adding the clause ROWNUM=1 to the query.

Cheers...David Received on Wed Oct 07 1998 - 00:00:00 CEST