TapeTrack Documentation

Because there is more to tape management than you ever realized

Trace: • setsql

engine:import:setsql

Book Creator
Add this page to your book

Book Creator
Remove this page from your book

Manage book(0 page(s))

Table of Contents

SetSql
- - Phase
  - Syntax
  - Example
  - Example

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

SetSQL: Select the Barcode and Location fields from Excel Spreadsheet workbook Inventory.

SetSQL(“SELECT Barcode,Location FROM [Inventory$]”);

engine/import/setsql.1550453215.txt.gz · Last modified: 2025/01/21 22:07 (external edit)