AddTranslationFromSQL

Translate the value of a field based a list of items loaded via an SQL query.

Phase

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");