ADO - Records v. Fields

[chkote]

This one has me puzzled (being new to ADO), how can I do
Recordset.RecordCount
and get the correct answer
do a count on fields and I get 0 ....Que??

 

[jfrost10]

Hmmm...although someone might have the answer here, maybe check the ADO forum, or the Visual Basic forum...they'd know for sure.

I checked with a code buddy of mine who uses recordsets, and she said that the recordset.recordcount is the correct way to get the number of records. Are you sure that your other code is working?
i.e. your objects are created correctly, the sql statement is actually returning something, etc.?

Jack

 

[jfrost10]

Oh, one other thing:

She said you HAVE to set this line of code:

Recordset.CursorLocation = adUseClient

or else it apparantly won't return the correct value.

Jack

 

[chkote]

Will post in another forum. My question wasn't worded too well. I actually do get the correct number of Records with adUseServer.
Thanks