skip to content
TapeTrack Documentation
Because there is more to tape management than you ever realized
User Tools
Log In
Site Tools
Search
Tools
Show page
Old revisions
Add to book
Export to PDF
Backlinks
Recent Changes
Media Manager
Sitemap
Log In
>
Recent Changes
Media Manager
Sitemap
Trace:
engine:import:setsql
====== 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);'' ^ Variable ^ Type ^ Description ^ Min Length ^ Max Length ^ |sql | String | The SQL string that will be used to query the SQL data source.| 1 | 512 | ===== Example ===== Select all fields from table volumes <code> SetSQL("SELECT * FROM [volumes]"); </code> Select the Barcode and Location fields from Excel Spreadsheet workbook Inventory. <code> SetSQL("SELECT Barcode,Location FROM [Inventory$]"); </code> {{tag> import_engine sync_engine}}
engine/import/setsql.txt
ยท Last modified: 2025/01/21 22:07 by
127.0.0.1
Page Tools
Show page
Old revisions
Backlinks
Add to book
Export to PDF
Back to top
