Returning rs.recordcount when it's -1 1

[TTThio]

Hi,

I'm taking data from ODBC. The rs.recordcount return -1 (Can't be determined). Is there another way to return the real number of records count?

Thanks a lot.

Tin Tin

 

[THoey]

Before you get the recordset, could you do a query to count the records?

SELECT count(*)
FROM MyTable;

Terry M. Hoey
th3856@txmail.sbc.com
While I don't mind e-mail messages, please post all questions in these forums for the benefit of all members.

 

[TTThio]

Terry,

that's actually the method that I can use to return records number. Thanks, problem is solved.

Tin Tin

 

[preebs]

You can use the query method or still use the recordset method - your choice. To get an accurate record count from the recordset, use the .MoveLast method first. Then the recordcount property will be accurate.