ODBC Manager Functions
Functions comprising the ODBC Manager library.
| Function | Description |
|---|---|
| AddConnection | Called to add a new DSN connection or get an existing one |
| BuildDelete | Builds a DELETE query |
| BuildInsert | Creates an INSERT query |
| BuildSelect | Creates a SELECT query |
| BuildUpdate | Creates an UPDATE query |
| ConvertToDbDate | Converts VTScada time to db date |
| ConvertToDbTime | Converts VTScada date to db time |
| ConvertToDbTimeStamp | Converts VTScada time/date to db time/date |
| ConvertToVTSDate | Converts db date to VTScada date |
| ConvertToVTSTime | Converts db time to VTScada time |
| ConvertToVTSTimeStamp | Converts db time/date to VTScada time/date |
| CopyRecords | A module for copying a record |
| DBDropList | Display drop list from db |
| DBGridList | Display grid list from db |
| ErrMessage | Converts error codes to ASCII strings |
| ExecuteQuery | Sends SQL commands & returns results |
| ExecuteQueryCached | Cache the query locally if it fails & send it to the db after the next successful transaction with the db. |
| FlushCache | Forces a flush of a cache file |
| FormatBatchQuery | Assembles array of queries into one |
| GetConnList | Returns a list of the available connections |
| ResultFormat | Reformats 2-d arrays |
| StatsWin | Called externally to show stats window |
| TableSynch | Synchs data tables in two different db's |
| Transaction | Starts a transaction within a DSN |
| TransactionCached | Starts a transaction with cache |
