Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Returns the ID that is assigned to a query column in the query definition.
Syntax
Number := Query.COLUMNNO(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: Integer
The number that is assigned to the column.
Remarks
In Query Designer, each column of the query is assigned a number that is specified by the column's ID Property. The COLUMNNO function enables you to create actions based on the ID of a column.
Example
The following example shows how to get the ID of 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 |
|---|---|---|
| Number | Integer | Not applicable |
| MyQuery | Query | My Customer Query |
This statement assigns the ID of the Customer_No column in the My Customer Query query to the Number variable.
Number := MyQuery.COLUMNNO("Customer_No");
See Also
How to: Create Queries
How to: Set Up Filter Rows in Query Designer
Queries
Record Data Type