====== 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}}