Differences

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

--- engine:import:setsql [2019/02/18 01:27] – old revision restored (2018/08/14 23:27) Scott Cunliffe
+++ 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;//
+^ 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 =====
+Select all fields from table volumes
+<code>
+SetSQL("SELECT * FROM [volumes]");
+</code>
-|sql| The SQL string that will be used to query the SQL data source.|
+Select the Barcode and Location fields from Excel Spreadsheet workbook Inventory.
-==== Example ====
+<code>
-**SetSQL: Select all fields from table volumes**
+SetSQL("SELECT Barcode,Location FROM [Inventory$]");
-|SetSQL("SELECT * FROM [volumes]");|
+</code>
-==== Example ====
+{{tag> import_engine sync_engine}}
-**SetSQL: Select the Barcode and Location fields from Excel Spreadsheet workbook Inventory.**
-|SetSQL("SELECT Barcode,Location FROM [Inventory$]");|