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.
Example
The following screenshot of a DataLookup data source shows several GetTableInfo examples: