This is an old revision of the document!

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

string field;
string sql;

field	The field to be translated.
sql	An SQL query to run to extract translation pairs.

AddTranslationFromSQL: Translate based on the values in a table.

AddTranslationFromSQL(VOLUME, "SELECT volume,barcode FROM barcodetable");