CitectSCADA SQL devices and Cicode functions also use the ODBC functions listed in the table below. While these functions are not necessary for operation, if they are absent in a driver, the error code 307 (SQL database error) will be returned if the ODBC driver does not support the necessary ODBC functions. To get the message associated with the error, call the Cicode function SQLErrMsg.
Level 0
SQLTransact |
If the driver does not support this function, the Cicode functions SQLBeginTran(), SQLCommit(), and SQLRollBack() are not supported. |
Level 1
SQLSpecial Columns |
CitectSCADA uses this function if it is available. There is no loss of functionality otherwise. |
SQLTables |
(no effect on CitectSCADA) |
Level 2
SQLData Sources |
The driver does not need to support this function. It is provided by ODBC. |
SQLExtended Fetch |
Without this function, CitectSCADA cannot take advantage of the native database's ability to fetch records at random. |
SQLSetScroll Options |
Without this function, CitectSCADA cannot take advantage of the native database's ability to fetch records at random. |
SQLMore Results |
(no effect on CitectSCADA) |
SQLNativeSql |
(no effect on CitectSCADA) |
SQLProcedure Columns |
(no effect on CitectSCADA) |
See Also