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

revDatabaseColumnNamed(recordSetID, columnName [, holderVariable ])

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

revDatabaseColumnNamed(myResults,"LASTNAME")
revDatabaseColumnNamed(zipSearch,"CARRIER","foundCarriers")
revDatabaseColumnNamed(tCursor, "id", "tRetrievedDataArray[id]")

Additional Comments
Expander triangle

Use the revDatabaseColumnNamed 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 function when the record set was created.

The columnName is the name of a database field.

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

Value:

The revDatabaseColumnNamed function returns the text from the specified field of the current record if no holderVariable is specified. If a holderVariable is specified the function returns empty if successful, an error string otherwise.

Comments:

If you specify a holderVariable, the data is placed in that variable. Otherwise, the data is returned by the function. Note that to retrieve binary data from the database, a holder variable must be specified, otherwise the revDatabaseColumnNamed 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 revDatabaseColumnNamed function returns an error message that begins with the string "revdberr".

Important! The revDatabaseColumnNamed 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 array elements as holder variables was added in version 2.9

The revDatabaseColumnNamed synonym was added in version 2.0.

User Comments
Expander triangle