====== 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.

===== Syntax =====
''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|

==== Example ====
AddTranslationFromSQL: Translate based on the values in a table.

<code>
AddTranslationFromSQL(VOLUME, "SELECT volume,barcode FROM barcodetable");
</code>

===== See Also =====

[[engine:import|Import Engine Functions]] \\
[[cli:sync_fields|Sync Engine Fields]] \\
[[cli:tmss10sync|TMSS10Sync]]

{{tag> import_engine sync_engine}}