engine:import:setsql
SetSQL
Set the SQL string that will be used to query the SQL data source.
Phase
This instruction is used by the TapeTrack Import Engine.
Syntax
SetSQL(sql);
sqlThe SQL string that will be used to query the SQL data source.
Example
SetSQL: Select all fields from table volumes
SetSQL("SELECT * FROM [volumes]");
Example
SetSQL: Select the Barcode and Location fields from Excel Spreadsheet workbook Inventory.
SetSQL("SELECT Barcode,Location FROM [Inventory$]");
engine/import/setsql.1550542490.txt.gz · Last modified: 2025/01/21 22:07 (external edit)
