Could you help please? RecordCount property returns only value -1, how to make it working?

__________________
Mr. Sokha Eap
Webmaster
UNDP Cambodia

it may provider which doesnot support this property
You can determine whether your recordset supports the RecordCount property by
    using the Recordset object’s Supports method with the dApproxPosition or AdBookmark parameters, as demonstrated in the following code:

blnApproxPos = rsExample.Supports(adApproxPosition)
blnBookmark = rsExample.Supports(adBookmark)

If the value of blnApproxPos or blnBookmark is True, then RecordCount immediately reflects the actual number of records in the recordset.

the Recordset object cursortype must also supports movement (forward and backward) like set to adOpenStatic


Ahmed Ali
Software Developer

make your recordet to point to 1st record and then again try to recordcount..
Rahil

Looking Forward For Your Prompt Reply

Where they should be placed if compared to the recordset execution line?
blnApproxPos = rsExample.Supports(adApproxPosition)
blnBookmark = rsExample.Supports(adBookmark)

What should I do if both variables return value FALSE?

supports method for recordset object is a test if recordset or other ado objects support certain property so before use this proberty test if it's supported.

Q?
what database you are connecting to?
if possible show us some of the code has the problem?

....

Ahmed Ali
Software Developer

This may help to resolve your problem. I experienced it several years ago when I first went to ADO.

By default, the Microsoft ODBC Driver or OLE DB Provider creates a server-side recordset with a CursorType of forward-only (adOpenForwardOnly). A forward-only cursor does not support the RecordCount property, even if you move to the last record in the recordset after you've opened it.

If you need the RecordCount to be correct, then set the CursorType to something other than forward-only (e.g. adOpenKeyset or adOpenStatic). Using a dynamic cursor (adOpenDynamic) will not help in this case since the number of records in a dynamic cursor may change.

If you create a client-side recordset (adUseClient), then ADO automatically sets the CursorType to a static cursor (adOpenStatic), and hence the RecordCount property will always be correct for "client-side" recordsets.

For more info, see Microsoft KB Article Q194973



Larry Asher

Forward only cursortype would always return the record count as "-1" only.

Best Regards
Vadivel

MVP ASP/ASP.NET
http://vadivel.thinkingms.com