revDatabaseColumnNames

returns the list of database field names in a record set or a database table

# Metadata

Platforms: desktop, server, mobile OS: mac, windows, linux, ios, android Introduced: 1.1 Security: disk, network

# Syntax

revDatabaseColumnNames(recordSetOrConnectionId [, tableName])

# Params

- recordSetOrConnectionId : The recordSetOrConnectionId is either the number returned by the revQueryDatabase when the record set was created or the number returned by the revOpenDatabase function when the connection was created. - tableName : The name of a table in the current database. A table name should be specified if the recordSetOrConnectionId parameter is a connection id.

# Examples

revDatabaseColumnNames(foundResults)

get revDatabaseColumnNames(field "Current Results")

get revDatabaseColumnNames(tConnectionId, "myTable")

# Description

Use the revDatabaseColumnNames function to find out what database fields are in the record set returned by a SQL query or what database fields are contained within a certain table.

There are two forms of the revDatabaseColumnNames function. It can either be used to return the list of column names in a record set, or as of version 2.9, the list of columns in a given table.

To get the list of columns in a record set use a form like this:

get revDatabaseColumnNames(tRecordSetId)

To get the list of columns in a given table, use a form like this:

get revDatabaseColumnNames(tConnectionId, "myTable")

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

>*Important:* The revDatabaseColumnNames function is part of the > Database library. To ensure that the function works in a > standalone application, you must include this > LiveCode custom library when you create your > standalone application. In the Inclusions pane of the > Standalone Application Settings window, make sure both the > "Database" library checkbox and those of the database drivers you are > using are checked.

# Tags

database,

# See

- **keyword:** string - **control structure:** function - **function:** revDatabaseColumnCount, revDatabaseColumnNamed, revDatabaseColumnTypes, revDatabaseColumnIsNull - **library:** Database library - **glossary:** LiveCode custom library, database field, Standalone Application Settings, standalone application, record set, return, SQL query