This is an old revision of the document!

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