Name: revDatabaseCursors

Synonyms: revdb_cursors

Type: function

Syntax: revDatabaseCursors(<databaseID>)

Summary:
<return|Returns> the <record set> IDs associated with a connection 
to a <database>.

Associations: database library

Introduced: 1.1

OS: mac, windows, linux, ios, android

Platforms: desktop, server, mobile

Security: disk, network

Example:
revDatabaseCursors(weeklyReportsDB)

Example:
put the number of items of revDatabaseCursors(2) into numberOfSets

Example:
repeat for each item thisResultSet in revDatabaseCursors(myDB)

Parameters:
databaseID:
The number returned by the revOpenDatabase function when the database
was opened.

Returns:
The <revDatabaseCursors> <function> returns a list of record set IDs
separated by commas.

Description:
Use the <revDatabaseCursors> <function> to perform an operation on each
<record set>, or to find out how many <record set|record sets> exist 
on a particular <database> connection.

The record set IDs returned are those opened by the specified
<databaseID>. 

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

Changes:
The revDatabaseCursors synonym was added in version 2.0.

References: revCloseCursor (command), function (control structure),
Standalone Application Settings (glossary), database (glossary),
standalone application (glossary), record set (glossary), 
return (glossary), LiveCode custom library (glossary), 
Database library (library)

Tags: database

