ADO Recordsets

[Guest_imported]

Hello,

I have some troubles with ADO Recordsets.
I have created an ADODB Recordset.
In the next step I make an SQL Query on an Microsoft SQL Server. The data are collected within the recordset.
My problem:

I have more sets of data within the recordset, which have the same ID, but the dates are different.
There exists no FindNext, FindLast .. Method, to jump between the data sets.
I have to put them into a Form. It is lika a navigation menu I have created. With DAO I had no troubles, but would could I do, to jump between the data sets within the recordset?
Is there anyone who could help me?
Is there an other possibility like FindNext,FindLast .. -Methods as they exist in DAO?

Thanks

 

[delorfra]

Hi,

the ADO Find method has replaced the FindNext, FindLast etc ... DAO methods.

Try this link :

http://www.devguru.com/Technologies/ado/quickref/recordset_find.html

or this one to use a class that will simulate the findfirst .. actions :

http://www.1aspstreet.com/xq/ASP/txtCodeId.24967/lngWid.1/qx/vb/scripts/ShowCode.htm

or try to replace it with the seek method :

Seek with option (adSeekFirstEQ, adSeekLastEQ...)

Hope this helps



blygman@hotmail.com

François