TapeTrack Documentation

Book Creator
Add this page to your book

Book Creator
Remove this page from your book

Manage book(0 page(s))

Help

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); 80 string sql;

sql	The 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 A.46. SetSQL: Select the Barcode and Location fields from Excel Spreadsheet workbook Inventory. SetSQL(“SELECT Barcode,Location FROM [Inventory$]”);

Table of Contents

SetSQL

Phase

Syntax

Example