TapeTrack Documentation

Because there is more to tape management than you ever realized

Trace: • setsql

engine:import:setsql

This is an old revision of the document!

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);

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.1550484186.txt.gz · Last modified: 2025/01/21 22:07 (external edit)