Set the SQL string that will be used to query the SQL data source.
This instruction is used by the TapeTrack Import Engine.
SetSQL(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 |
Select all fields from table volumes
SetSQL("SELECT * FROM [volumes]");
Select the Barcode and Location fields from Excel Spreadsheet workbook Inventory.
SetSQL("SELECT Barcode,Location FROM [Inventory$]");