* * HELP & MANUAL PREMIUM PACK 4 DEMO VERSION * *
This documentation was styled with a demo skin from the Premium Pack 4 add-on for Help & Manual. The contents of the skin are encrypted and not configurable. You can only publish HM projects with this skin. You cannot edit it or change it.
This version is copyright and may only be used for local testing purposes. It may not be distributed.
Please purchase the full version of the Premium Pack to get the configurable skins and remove this notice. The package will also include the Toolbox configuration utility for Premium Pack skins.
Description
Returns a long value that indicates the number of records in a ADODB_Recordset object.
Syntax
n = <ADODB_Recordset>.RecordCount
Returns
Number
Parameters
Name |
Type |
Optional |
Meaning |
Remarks
This property will return:
•-1 for a forward-only cursor
•the actual count for a static or keyset cursor
•-1 or the actual count for a dynamic cursor.
Restrictions
The ADODB_Recordset object must be open when calling this property. If this property is not supported it will return -1.
If the ADODB_Recordset object supports AbsolutePosition and AbsolutePage properties or bookmarks, this property will return the exact number of records in the ADODB_Recordset.
NOTE
If property will return -1, and SQL syntax is ok and ADODB_Recordset.State is %adStateOpen also check ADODB_Recordset.CursorLocation property.
Default value is %adUseServer, changing to %adUseClient can solve the problem.
Also check ADODB_Connection.CursorLocation property: changing to %adUseClient can solve the problem.
See also
Examples
