Execute external SQL queries from file
Description
An iX-script module that executes SQL queries specified in a file “SQL.txt”
Target device: X2 series, C2 series, iX PC RT (iX runtime)
Update information
An iX-script module that executes SQL queries specified in a file “SQL.txt”.
This file can either be transferred via FTP to the device or via USB stick or SD card. Multiple queries can be specified inside the “SQL.txt”.
The script module generates a “Result.txt” and (depending on the query) a folder named according to the actual date and a XLS result file inside. The target folder is the same as the folder of the “SQL.txt” (SD/USB or Project Files). After processing the “SQL.txt” the file is renamed to “SQLBackup.txt”.
Version history
• Package V1.1.1 is the first released version (2021-01-27)
Developed and supported for:
• iX Developer 2.40 SP4 / SP5
• X2 series devices, C2 series, iX PC RT (iX runtime)
Package file:
• SER0025_V1.1.1_package_iX_SqlQueryFtpUsbSd.zip
The zip file contains a iX sample project with script module and a quick start guide:
• SER0025_V1.1.1_iX_SqlQueryFtpUsbSd.zip (iX application)
• SER0025_QS_SqlQueryFtpUsbSd_V1.1.1-EN.pdf
Free for
United Extended level and above.
Read more about the UNITED partner program:
click here
Note! If you previously downloaded the package file from SmartStore, find the download link in submenu My account > My apps, when logged in!
Related documents
SER0025_QS_SqlQueryFtpUsbSd_V1.1.1-EN.pdf
