Skip to content

Get_FileNumber

Purpose

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

Syntax

Get_FileNumber TableName.ColumnName to integer_variable

What It Does

This command returns the table 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.

An equivalent statement to:

Get_FileNumber Customer.Name to iTable

is:

Move Customer.File_Number to iTable.

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.