Error getting tags :
error 404Error getting tags :
error 404 revDatabaseColumnCount | revDocs | RunRev
Welcome Guest (Log in)
Product Edition
Version
revDatabaseColumnCount
Basics
Expander triangle
Type
Function
Syntax

revDatabaseColumnCount(recordSetID)

Introduced
1.1
Changed
2.0
Environment
Desktop, Web and Server
Platform Support
MacOS,Mac OS X,Windows,Linux
Security
Disk,Network
Summary
Returns the number of database fields in a record set (database cursor).
Examples

revDatabaseColumnCount(12)
revDatabaseColumnCount(the savedResultsPointer of this card)

Additional Comments
Expander triangle

Use the revDatabaseColumnCount function to find out how many database fields you must deal with in a record set (database cursor).

Parameters:

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

Value:

The revDatabaseColumnCount function returns either positive integer or the number -1.

Comments:

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

Note: Some database systems will not give the columm count until all the records in a record set have been fetched. This is for efficiency reasons. When the column count is not available the revDatabaseColumnCount will return a value of -1. This is currently applicable to Oracle databases and certain ODBC data sources.

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

The revDatabaseColumnCount synonym was added in version 2.0.

User Comments
Expander triangle