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

revDatabaseColumnNumbered(recordSetID,columnNumber[,variable])

Introduced
1.1
Changed
2.9
Environment
Desktop, Web and Server
Platform Support
MacOS,Mac OS X,Windows,Linux
Security
Disk,Network
Summary
Returns data from a specified database field.
Examples

revDatabaseColumnNumbered(customerServiceDB, 3)
revDatabaseColumnNumbered(7, 3, "tNewColumn") -- puts column 3 into tNewColumn
revDatabaseColumnNumbered(USCustomers, x, "tFoundZipCodes")
revDatabaseColumnNumbered(tCursor, 1, "tRetrievedDataArray[id]")

Additional Comments
Expander triangle

Use the revDatabaseColumnNumbered function to obtain the contents of a given database field, in the current record of the specified record set (database cursor).

Parameters:

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

The columnNumber is the number of a database field.

The holderVariable is any valid variable name or the name of an array element.

Value:

The revDatabaseColumnNumbered function returns or text data from the specified field of the current record, if no holderVariable is specified. If a holderVariable is specified, then the function returns empty.

Comments:

If you specify a holderVariable, the data is placed in that variable. Otherwise, the data is returned by the function. Note that in order to retrieve binary data, a holder variable must be specified, otherwise the revDatabaseColumnNumbered function may return truncated data. This is due to limitations in the current architecture.

If the attempt to get the data is not successful, the revDatabaseColumnNumbered function returns an error message that begins with the string "revdberr".

Important! The revDatabaseColumnNumbered 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 ability to specify an array element as a holder variable was added in version 2.9.

The revDatabaseColumnNumbered synonym was added in version 2.0.

User Comments
Expander triangle