Name: revCurrentRecordIsLast

Type: function

Syntax: revCurrentRecordIsLast(<recordSetID>)

Summary: <return|Returns> whether the current <record> is the last <record> in a <record set (database cursor)(glossary)>.

Introduced: 1.1

OS: mac,windows,linux,ios,android

Platforms: desktop,server,web,mobile

Security: disk,network

Example:
revCurrentRecordIsLast(3)

Example:
if revCurrentRecordIsLast(testMySQL) then exit repeat

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

Returns: The <revCurrentRecordIsLast> <function> returns true if there are no more <record|records>, false otherwise.

Description:
Use the <revCurrentRecordIsLast> <function> to stop when you reach the end of the <record|records>.

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

>*Important:*  The <revCurrentRecordIsLast> <function> is part of the <Database library>. To ensure that the <function> works in a <standalone application>, you must include this <Revolution custom library|custom library> when you create your <standalone application|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:
The revCurrentRecordIsLast synonym was added in version 2.0.

References: string (keyword), Database library (library), Revolution custom library (library), revMoveToNextRecord (command), revdb_movefirst (function), revdb_moveprev (function), revdb_movelast (function), revdb_movenext (function), record (glossary), Standalone Application Settings (glossary), standalone application (glossary), record set (database cursor) (glossary), return (glossary), function (control_st)

Tags: database
