[AN1554]

I want to check if a record with ID 1 exists.

rs.Open "SELECT * FROM tblTransaction WHERE TransactionID = 1", DBConn

There are no records with ID 1. rs.Fields.Count returns 9. How can it?

This post has been edited by AN1554: 28 April 2012 - 06:54 AM

[Atli]

I would guess that even though the result set has no data, the meta-data for the result set is being sent, including the number of fields should be in each row.


But I would question your method there. Why, if you are only interested in seeing if the row exists, are you attempting to fetch all the data in the row? Unless you actually need the data, you should not be fetching it. It's a waste of resources. - Instead, use the COUNT() function to see how many rows there are.

I'm no VB coder, but I'd imagine it being something like this:

rs.Open "SELECT COUNT(*) FROM tblTransaction WHERE TransactionID = 1", DBConn
Set rowCount = CInt(rs(0))

[AN1554]

I did not think about COUNT. rs.Fields.Count returns the number of fields, not the number of records fetched by the recordset, which rs(0) returns.

This post has been edited by AN1554: 28 April 2012 - 07:57 AM