Name: revDatabaseColumnNumbered

Type: function

Syntax: revDatabaseColumnNumbered(<recordSetID>, <columnNumber> [, <variable>])

Summary: <return|Returns> data from a specified <database field>.

Synonyms: revdb_columnbynumber

Introduced: 1.1

OS: mac,windows,linux,ios,android

Platforms: desktop,server,web,mobile

Security: disk,network

Example:
revDatabaseColumnNumbered(customerServiceDB, 3)

Example:
revDatabaseColumnNumbered(7, 3, "tNewColumn") -- puts column 3 into tNewColumn

Example:
revDatabaseColumnNumbered(USCustomers, x, "tFoundZipCodes")

Example:
revDatabaseColumnNumbered(tCursor, 1, "tRetrievedDataArray[id]")

Parameters:
recordSetID: The number returned by the revQueryDatabase when the record set was created.
columnNumber: The number of a database field.
variable: 
holderVariable: Any valid variable name or the name of an array element.

Returns: 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.

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

If you specify a <holderVariable>, the data is placed in that <variable>. Otherwise, the data is <return|returned> by the <function>. 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 <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 ability to specify an array element as a holder variable was added in version 2.9.

References: string (keyword), Database library (library), Revolution custom library (library), revMoveToLastRecord (command), revMoveToFirstRecord (command), revMoveToNextRecord (command), revDatabaseColumnCount (function), revCurrentRecord (function), revDatabaseColumnNamed (function), revDatabaseColumnLengths (function), revDatabaseColumnIsNull (function), return (glossary), variable (glossary), record set (database cursor) (glossary), record (glossary), Standalone Application Settings (glossary), standalone application (glossary), database field (glossary), function (control_st)

Tags: database
