Translate the value of a field based a list of items loaded via an SQL query.
This instruction is used by the TapeTrack Import Engine.
AddTranslationFromSQL(field, sql);
| Variable | Type | Description | Min Length | Max Length |
|---|---|---|---|---|
| field | String | The field to be translated. | 1 | 128 |
| sql | String | An SQL query to run to extract translation pairs. | 1 | 256 |
AddTranslationFromSQL: Translate based on the values in a table.
AddTranslationFromSQL(VOLUME, "SELECT volume,barcode FROM barcodetable");