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

revCurrentRecord(recordSetID)

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

revCurrentRecord(bookSearchResults)
put revCurrentRecord(it) into myRecordNumber

Additional Comments
Expander triangle

Use the revCurrentRecord function to find out which record is currently being used.

Parameters:

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

Value:

The revCurrentRecord function returns a number between 0 and the number of records in the record set - 1. The number represents the zero-based index of the current record. (i.e. 0 is the first record, 1 is the second etc)

Comments:

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

If the revCurrentRecord function returns a value of 0, this means that the cursor is at the start of the record set, pointing to the first record. Fetching data (with revDatabaseColumnNamed or revDatabaseColumnNumbered) will retrieve the first record.

If the revCurrentRecord function returns a value of equal to the number of records -1, this means that the cursor is on the last record. Fetching data will retrieve the last record.

Important! The revCurrentRecord function 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 revCurrentRecord synonym was added in version 2.0.

User Comments
Expander triangle