RunSQL.exe utility program
The Sigma system provides a comprehensive interface to SQL databases using the "RunSQL.exe" program, found in the "system" directory of the Sigma root directory. This utility permits users to run arbitrary SQL statements.
Using the Runs program in conjunction with the Sigma "Macro" capability (described in Using-Sigma-Web-Framework) allows developers to easily create web pages containing data directly acquired from any ODBC database, including Oracle, Microsoft Access, and Microsoft SQL databases.
The RunSQL.exe program requires the user to create a configuration file defining the ODBC interface to operate upon. The configuration file can also contain the query to execute, or the query can be placed on the command line. The actual syntax of the Runs program takes two forms:
Function | Description |
|---|---|
Runsql.exe (configfilepath) | This form of the command requires the pathname to a configuration file to be specified. The configuration file contains "dsnname", "username", "password", and possibly other optional directives. In this form of the command, the "sqlstmt" directive MUST be included, and contains a standard SQL query that is executed by the RunSQL program. |
Runsql.exe (configfilepath) (sqlstmt) | This form of the command requires the pathname to a configuration file, identical to the above form, but also accepts an SQL query as part of the command line. The query is limited to 500 characters or less. If a query is specified in the configuration file, the command line query is ignored. |
Related topics