Error getting tags :
error 404Error getting tags :
error 404 revNumberOfRecords | revDocs | RunRev
Welcome Guest (Log in)
Product Edition
Version
revNumberOfRecords
Basics
Expander triangle
Type
Function
Syntax

revNumberOfRecords(recordSetID)

Introduced
1.1
Changed
2.0
Environment
Desktop,Server,Web
Platform Support
MacOS,Mac OS X,Windows,Linux
Security
Disk,Network
Summary
Returns the number of records in a record set (database cursor).
Examples

revNumberOfRecords(westCoastCustomers)

get revNumberOfRecords(15) -- number of records in record set 15

repeat for revNumberOfRecords(pastDueCustomers) times

Additional Comments
Expander triangle

Use the revNumberOfRecords function to find out how many records matched a query.

Parameters:

The recordSetID is the number returned by the revQueryDatabase function when the record set was created.

Value:

The revNumberOfRecords function returns either a non-negative integer or -1 if the number of records could not be determined.

Comments:

If the query is not successful, the revNumberOfRecords function returns an error message that begins with the string "revdberr".

Some database types do not support returning the number of records in a result set. One example of this is ODBC data sources with forward-only cursors. If the database does not support this feature, the revNumberOfRecords function will return -1.

Important! The revNumberOfRecordsfunction is part of the Database library. To ensure that the function works in a standalone application, you must include this custom library when you create your standalone. In the Inclusions section of the General screen of the Standalone Application Settings window, make sure the "Database Support" checkbox is checked and the database drivers you are using are selected in the list of database drivers.

Changes to Revolution:

The revNumberOfRecords synonym was added in version 2.0.

User Comments
Expander triangle