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.

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$]");