TapeTrack Documentation

Because there is more to tape management than you ever realized

User Tools

Site Tools

Trace:
engine:import:setsql

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
engine:import:setsql [2020/03/03 23:28] – Scott Cunliffeengine:import:setsql [2025/01/21 22:07] (current) – external edit 127.0.0.1
Line 9: Line 9:
 ''SetSQL(sql);'' ''SetSQL(sql);''
  
-string //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 |
-|sql | The SQL string that will be used to query the SQL data source.|+
  
 ===== Example ===== ===== Example =====
Line 17: Line 16:
 Select all fields from table volumes Select all fields from table volumes
  
-<sxh>+<code>
 SetSQL("SELECT * FROM [volumes]"); SetSQL("SELECT * FROM [volumes]");
-</sxh>+</code>
  
  
 Select the Barcode and Location fields from Excel Spreadsheet workbook Inventory. Select the Barcode and Location fields from Excel Spreadsheet workbook Inventory.
  
-<sxh>+<code>
 SetSQL("SELECT Barcode,Location FROM [Inventory$]"); SetSQL("SELECT Barcode,Location FROM [Inventory$]");
-</sxh>+</code>
  
 {{tag> import_engine sync_engine}} {{tag> import_engine sync_engine}}
engine/import/setsql.1583278101.txt.gz · Last modified: 2025/01/21 22:07 (external edit)