1. [url removed, login to view] project
2. Small user interface with just a "Start" button.
3. Callable from a command line, so it can be called from Windows Scheduler or other processes, and run hidden.
4. Application functions
a. Connect to SQLServer database (or any ODBC-compliant DB)
b. Open command table in DB (see structure below) and executes all active commands
c. Command will execute a SELECT SQL statement and package the results into a formatted JS file.
d. File location will be as specified in the command table; if destination is NULL, default will be current local folder
e. Application will create/add to a log file to document performed actions.
5. Calling parameter (optional)
a. If a calling parameter is used, this is a selection criteria to use when choosing command lines to execute
ii. Executes only command lines with CSet = "Ref1"
6. Read intialization file
a. File Name = [url removed, login to view]
<Prefix>text to prefix data in the file<\Prefix>
<Suffix>text to add as suffix to data in the file<\Suffix>
7. Include a config text file that specifies the DB connection parameters
| Field name | Type | Description/use | Example |
| CSet | C 50 | Set (group) of command lines to execute | Ref1 (default is NULL) |
| CName | C 50 | Command line name/description | Get Projects |
| SQLText | Memo | The SQL command to be executed | SELECT * from Projects where?. |
| OutputName | C50 | The name of the JS file to be created | Projects |
| Olocation | Memo | The destination folder; if NULL then use current folder | C:\Myfiles |
| ActiveLine | Boolean | Denotes active line to execute as part of set | True (default value) |