Differences

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

--- engine:import:setsql [2019/02/19 02:43] – [Example] Scott Cunliffe
+++ engine:import:setsql [2025/01/21 22:07] (current) – external edit 127.0.0.1
@@ Line 3: / Line 3: @@
 Set the SQL string that will be used to query the SQL data source.
-==== Phase ====
+===== Phase =====
 This instruction is used by the TapeTrack Import Engine.
-==== Syntax ====
+===== Syntax =====
-**SetSQL**//(sql);//
+''SetSQL(sql);''
-  * ''sql'' The SQL string that will be used to query the SQL data source.
+^ Variable ^ Type ^ Description ^ Min Length ^ Max Length ^
+|sql | String | The SQL string that will be used to query the SQL data source.| 1 | 512 |
-==== Example ====
+===== Example =====
-SetSQL: Select all fields from table volumes
-<sxh plain;>
+Select all fields from table volumes
+<code>
 SetSQL("SELECT * FROM [volumes]");
-</sxh>
+</code>
-==== Example ====
+Select the Barcode and Location fields from Excel Spreadsheet workbook Inventory.
-SetSQL: Select the Barcode and Location fields from Excel Spreadsheet workbook Inventory.
+<code>
+SetSQL("SELECT Barcode,Location FROM [Inventory$]");
+</code>
-<sxh>SetSQL("SELECT Barcode,Location FROM [Inventory$]");</sxh>
+{{tag> import_engine sync_engine}}