Livecode Wiki
Advertisement

Moves to the next record in a record set (database cursor)(glossary).Syntax:

revMoveToNextRecord <recordSetID>

Examples:

revMoveToNextRecord myCurrentItems
revMoveToNextRecord (line x of field "Current Recordsets")

Use the revMoveToNextRecord command to move around within the selected set of records.

Not all databases support the revMoveToNextRecord command. All the major database types that LiveCode can connect to do support this, however certain ODBC data sources may not, if in doubt, refer to the documentation for your ODBC data source driver.

The revMoveToNextRecord command is part of the 

Database library. To ensure that the command works in a standalone application, you must include this custom library when you create your standalone. In the Inclusions pane of the Standalone Application Settings window, make sure both the "Database" library checkbox and those of the database drivers you are using are checked.

Parameters:

  • recordSetID: The number returned by the revQueryDatabase function when the record setwas created.
  • The result: If the command could not move to the next record because it's already atthe end or there are no records in the record set, the result functionreturns false.

See also: revMoveToPreviousRecord (command),revMoveToLastRecord (command),function (control structure),revdb_movefirst (function),revdb_movelast (function),revCurrentRecordIsFirst (function),revQueryIsAtEnd (function),revdb_moveprev (function),revCurrentRecord (function),revCurrentRecordIsLast (function),revNumberOfRecords (function),revDatabaseColumnNumbered (function),revdb_movenext (function),Database library (library),

Advertisement