Applies To:
  • CitectSCADA 1.00 1.01 1.10 1.11 1.20 2.00 2.01

Summary:
It is very easy to misuse some of the SQL Functions in Cicode. If you do not end a query (SQLEnd() after a SQLExec()), then system resources are not freed. If you do not terminate a transaction (SQLRollback() or SQLCommit() after a SQLBeginTran()), then the connection to the database cannot be disconnected Depending on where the database server resides, this will mean that either the PC will run out of connection sockets, or that Citect will have tens (or even hundreds) of connections to a database. 

Solution:
You must allways end a SQLExec() with an SQLEnd(). You must also end a SQLBeginTran() with a SQLCommit() or SQLRollback(). 

Keywords:
 

Attachments