Nomatch property in ADO

[jbrowne]

Hi Folks,
Can anyone tell me what is the equivelent of the nomatch property (DAO) when using ADO. If, as I suspect there is none, what is the best way of coding around it ?
Thanks

John B

 

[WP]

You'll find what you need in :

http://msdn.microsoft.com/library/officedev/odeopg/deovrfindingrecordsinrecordsetobject.htm

I found this psge by searching in

http://www.google.com

for ADO + NoMatch + Seek.


Bill Paton
william.paton@ubsw.com

http://www.neptune400.co.uk/

Check out my website !

 

[jeba]

When I try to use table.seek with the 4.0 Jet in VB6 I get an error 3251 stating that "the object or provider is not capable of performing requested operation"

Why is that? I thought you could use seek with Jet 4.0

Thanks,

Jim

 

[jeba]

I resolved the problem. I was using Jet 4.0 OLEDB and trying to access an Access 97 database. When I converted the db to Access 2000, the seek command worked.

This pretty much ties ones hands. DAO can't access 2000 and Jet 4.0 can't work with access 97.

 

[caf]

You test for .EOF after issuing a find statement.

Example

YourRecordSet.Find(blah blah blah....

If YourRecordSet.EOF Then
'No Mathcing records
Else
'A Match was found.
End If

Have fun
caf