AX1650

GetTableInfo data lookup

You can use GetTableInfo rows in a DataLookup data source to return information about a specified table.

The GetTableInfo data lookup supports similar query parameters as the GetTableInfo function, and can be used as a substitute for this function to improve file performance. The data lookup is intended to be used in cases where the queried value is not expected to change during the current file session, and therefore the value only needs to be queried once (or only after specific events).

To create a GetTableInfo data lookup, add a [GetTableInfo] row to a DataLookup data source and add the appropriate parameter columns. For more information on creating the DataLookup data source, see Creating DataLookup data sources.

GetTableInfo parameters

[GetTableInfo] rows use the following parameter columns. Within the DataLookup control row, these parameter names must be placed in square brackets—for example, [CodeName]. The parameters can be placed in any order.

NOTE: If the entry for any parameter depends on a value returned by another data lookup row, then that row must be in a different data source and executed before this row is executed. For more information, see Dependent data lookups.

Parameter Description

Parameter	Description
CodeName	Specifies the table property to return. Use one of the following values: `Classification`: Returns the table classification for the table, such as Data or Reference. `Exists`: Returns whether the table exists in the system (True/False). `IndexScheme`: Returns the index scheme for the table, such as Default or Large Table. `IsReadOnly`: Returns whether the table is read-only (True/False). `TableType`: Returns the table type that the table is assigned to (blank if the table is not assigned to a table type). The following options only apply to product systems, and are configured by product development and implementation consultants: `CustomerTableName`: Returns the real name of the table. `IsUnused`: Returns whether the table is flagged as unused (True/False). Note that currently this flag does not affect the table; it is reserved for future functionality. `IsVariable`: Returns whether the table is flagged as variable (True/False). `PreferredName`: Returns the preferred name of the table.
TableName	The name of the table for which you want to return information. NOTE: If the table does not exist in the current system, the only code that will return a response is Exists. Otherwise, using an invalid table name will return an error.

CodeName

Specifies the table property to return. Use one of the following values:

Classification: Returns the table classification for the table, such as Data or Reference.
Exists: Returns whether the table exists in the system (True/False).
IndexScheme: Returns the index scheme for the table, such as Default or Large Table.
IsReadOnly: Returns whether the table is read-only (True/False).
TableType: Returns the table type that the table is assigned to (blank if the table is not assigned to a table type).

The following options only apply to product systems, and are configured by product development and implementation consultants:

CustomerTableName: Returns the real name of the table.
IsUnused: Returns whether the table is flagged as unused (True/False). Note that currently this flag does not affect the table; it is reserved for future functionality.
IsVariable: Returns whether the table is flagged as variable (True/False).
PreferredName: Returns the preferred name of the table.

TableName

The name of the table for which you want to return information.

NOTE: If the table does not exist in the current system, the only code that will return a response is Exists. Otherwise, using an invalid table name will return an error.

Example

The following screenshot of a DataLookup data source shows several GetTableInfo examples: