Differences

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

--- engine:import:setsql [2018/08/14 23:26] – created dcumming
+++ engine:import:setsql [2025/01/21 22:07] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
-setsql
+====== SetSQL ======
-==== SetSQL ====
 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);''
-string //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**
-|SetSQL("SELECT * FROM [volumes]");|
+Select all fields from table volumes
-Example A.46. SetSQL: Select the Barcode and Location fields from Excel
-Spreadsheet workbook Inventory.
+<code>
+SetSQL("SELECT * FROM [volumes]");
+</code>
+Select the Barcode and Location fields from Excel Spreadsheet workbook Inventory.
+<code>
 SetSQL("SELECT Barcode,Location FROM [Inventory$]");
+</code>
+{{tag> import_engine sync_engine}}