Differences

This shows you the differences between two versions of the page.

--- engine:import:addtranslationfromsql [2018/08/14 22:32] – created dcumming
+++ engine:import:addtranslationfromsql [2025/01/21 22:07] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
-addtranslationfromsql
+====== AddTranslationFromSQL ======
-==== AddTranslationFromSQL ====
 Translate the value of a field based a list of items loaded via an SQL query.
-==== Phase ====
+===== Phase =====
 This instruction is used by the TapeTrack Import Engine.
-==== Syntax ====
+===== Syntax =====
-**AddTranslationFromSQL**//(field, sql);//
+''AddTranslationFromSQL(field, sql);''
-//string field;//\\
+^ Variable ^ Type ^ Description ^ Min Length ^ Max Length ^
-//string sql;//\\
+|field| String | The field to be translated.|1|128|
+|sql| String | An SQL query to run to extract translation pairs.|1|256|
-|field| The field to be translated.|
-|sql| An SQL query to run to extract translation pairs.|
 ==== Example ====
-**AddTranslationFromSQL: Translate based on the values in a table.**
+AddTranslationFromSQL: Translate based on the values in a table.
-|AddTranslationFromSQL(VOLUME, "SELECT volume,barcode FROM barcodetable");|
+<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}}