Recordcount returning -1

[robinsql]

Hi,

Can somebody please explain why this returns -1 as the recordcount when there are in fact, two records?

rs.Open sSQL, m_Conn, adOpenKeyset, adLockOptimistic
lNoOfCartons = rs.RecordCount

Thanks,

Robin

 

[hmckillop]

The recordset is returning -1 because of the type of recordset you are opening. Try changing the recordset to static and see if you get the correct recordcount.

 

[zemp]

A key set cursor will initially only return a key or keys to the row(s) of data. The data is fetched and the recordscount incremented, using the key, when you actually move through the recordset. As a result the inital recordcount does not exist and returns a -1.

Take Care,

zemp

"Show me someone with both feet on the ground and I will show you someone who can't put their pants on."