revCurrentRecordIsLast

returns whether the current record is the last record in a record set .

# Metadata

Platforms: desktop, server, mobile OS: mac, windows, linux, ios, android Introduced: 1.1 Security: disk, network

# Syntax

revCurrentRecordIsLast(recordSetID)

# Params

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

# Examples

revCurrentRecordIsLast(3)

if revCurrentRecordIsLast(testMySQL) then exit repeat

# Description

Use the revCurrentRecordIsLast function to stop when you reach the end of the 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 > LiveCode custom library when you create your > standalone application. 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.

# Tags

database,

# See

- **keyword:** string - **glossary:** LiveCode custom library, record, Standalone Application Settings, standalone application, record set, return - **command:** revMoveToNextRecord - **function:** revdb_movefirst, revdb_moveprev, revdb_movelast, revdb_movenext - **library:** Database library - **control structure:** function