The Table Syntax

The Table Syntax

In a few cases like User defined Fields we have a window that behind have some data but the data is not shown to the user. If that is the case we use the table syntax instead.

Here we have a user defined field called Kit Number but since it is only part of the side-bar and not part of the main window we need to use the table syntax:

$[<TableName>.<FieldId>.<DataType>]

Working the same way as with the item-syntax we need to provide the 3 values needed.

The table the field is on is ORDR and the field is U_KitNo

The data type is string (STRING or 0)

If we used this in an SQL-sentence:

SELECT $[ORDR.U_KitNo.0] = SELECT 'A1234'