COLUMNNAME Function
Returns the name of a query column as a text string.
Name := Query.COLUMNNAME(Column)
Parameters
- Query
Type: Query A variable that specifies the query object that contains the column.
- Column
Type: Text Refers to the name of the query column. The name of a query column is specified by the Name Property of the column in Query Designer.
Property Value/Return Value
Type: Text
The name of the specified column.
Remarks
The COLUMNNAME function retrieves the name of the column as specified by its Name property and enables you to create actions based on the column name. If you want to retrieve the query column's caption, which displays in the user interface of the query, then call the COLUMNCAPTION Function instead.
Example
The following example shows how to get the name for a column of a query. The query is called My Customer Query and has a column with the name Customer_No. This example requires that you create the following variables.
| Variable name | DataType | Subtype | Length |
|---|---|---|---|
NameOfColumn |
Text |
Not applicable |
64 |
MyQuery |
Query |
My Customer Query |
Not applicable |
NameOfColumn := MyQuery.COLUMNNAME("Customer_No");
The name of the column is stored in a text string.
The advantage of using this statement instead of assigning the column name in a statement, such as NameOfColumn := 'Customer_No';, is that the COLUMNNAME function dynamically adapts to any change to the column name that is made in the development environment. The NameOfColumn := 'Customer_No'; statement performs a static assignment.
See Also
Tasks
How to: Create Queries
How to: Set Up Filter Rows in Query Designer