Citect SCADA 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 |
Citect SCADA uses this function if it is available. There is no loss of functionality otherwise. |
|
SQLTables |
(no effect on Citect SCADA) |
Level 2
|
SQLData Sources |
The driver does not need to support this function. It is provided by ODBC. |
|
SQLExtended Fetch |
Without this function, Citect SCADA cannot take advantage of the native database's ability to fetch records at random. |
|
SQLSetScroll Options |
Without this function, Citect SCADA cannot take advantage of the native database's ability to fetch records at random. |
|
SQLMore Results |
(no effect on Citect SCADA) |
|
SQLNativeSql |
(no effect on Citect SCADA) |
|
SQLProcedure Columns |
(no effect on Citect SCADA) |
See Also
Published June 2018