Name: revDatabaseCursors

Type: function

Syntax: revDatabaseCursors(<databaseID>)

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

Synonyms: revdb_cursors

Introduced: 1.1

OS: mac,windows,linux,ios,android

Platforms: desktop,server,web,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 (database cursor)|record set>, or to find out how many <record set (database cursor)|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 <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 revDatabaseCursors synonym was added in version 2.0.

References: revCloseCursor (command), function (control_st), Standalone Application Settings (glossary), database (glossary), standalone application (glossary), record set (database cursor) (glossary), return (glossary), Database library (library), Revolution custom library (library)

Tags: database
