Hi Gary ,
The best solution to get data from a SQL Server into Citect is by using the SQL Cicode functions. Check out the online help:
https://gcsresource.aveva.com/Citect/WebHelp/citect800/default.htm#../Subsystems/CicodeReferenceCitectHTML/Content/SQL_Functions.html
There is also an implementation you can use as a guide in the Example project. It shows how to connect to the Alarm Database using ADO Connectivity. The cicode is called "DBAccess.ci" and the page where it is called is "DatabaseAccess".
Hi Gary ,
The best solution to get data from a SQL Server into Citect is by using the SQL Cicode functions. Check out the online help:
https://gcsresource.aveva.com/Citect/WebHelp/citect800/default.htm#../Subsystems/CicodeReferenceCitectHTML/Content/SQL_Functions.html
There is also an implementation you can use as a guide in the Example project. It shows how to connect to the Alarm Database using ADO Connectivity. The cicode is called "DBAccess.ci" and the page where it is called is "DatabaseAccess".
