SQL
Run the SQL queries in the file passed as a parameter.
Parameters
| Parameter number | Description | Optional |
|---|---|---|
| 1 | File containing the SQL queries to run | No |
Notes
The command displays the Windows Data Link Properties dialog box to select the database connection. If you cancel it, the command finishes. If the database connection fails, the command displays the error and finishes.
The file contains one query per line, with up to 1023 characters per line. Lines starting with # are comments. If a line contains $(TableName), the command runs it once for each database table, replacing $(TableName) with the table name.
If a query fails, the command plays an error sound, writes the error to the results window, and continues with the next line.
Command characteristics
| Command type | Immediate command |
|---|---|
| Repeats automatically | No |
| Menu option | This command has no associated menu option |
| Toolbar | This command has no associated toolbar button |
| Extension | DigiNG.OrdenesBaseDatos.dll |
| Implementation | Native |
| Related variables | No related variables |
| Related commands | No related commands |
| Internal name | {330E81D4-172A-4A8B-BE6E-FE8D9B79A9BF} |