Skip to content

Get_FieldNumber

Purpose

Returns the column number for the table and column passed as an argument at compile time.

Syntax

Get_FieldNumber TableName.ColumnName to integer_variable

What It Does

This command returns the column number for the table and column passed as an argument at compile time. It is very important to note that this happens at compile time.

Example

Integer iColumn iTable hDD
String sValue
Move Customer_DD to hDD
Get_FieldNumber Customer.Name to iColumn
Get_FileNumber Customer.Name to iTable
Get File_Field_Current_Value of hDD iTable iColumn to sValue

This example retrieves the table and column numbers of the Customer.Name database column and then retrieves the value of that column to the string variable sValue.

Notes

  • Whenever TableName.ColumnName is used as a parameter in a get/set command, these commands are executed at compile time.