Example on Search with SQL Statement

Example on Search with SQL Statement

Example on Search with SQL Statement

To search in the register of units of measurement:

U/M, select U/M, Name from U/M order by U/M

To search in the Items register:

acIdent; select acIdent, acName from tHE_SetItem

Multiselect of Items:

#CB;#acIdent; select acIdent, acName from tHE_SetItem

List:

List of materials example:

#LST;#plastic;glass;metal