SQL

Hi Joao ,
There are many ways to display a SQL Database table in Citect SCADA.
One way is to use an ActiveX control. Typically, customers have used the "Database Exchange" ActiveX control that ships with the product. Simply open a graphics page, click the insert ActiveX button, then select "DatabaseExchange.DataManager". Once it is inserted on the page, click the help button to open the CHM (help file) which details all the aspects that require configuration.
Another option is to use the Library Controls Include project, which contains some DB Display Genies (look in Example project > DatabaseAccess and DatabaseDisplay pages, SQL Table control).
Kind regards
Olivier

Hello Olivier,

The ActiveX "DatabaseExchange.DataManager" already knew but the graphip aspect seems to be a bit old.

I have been investigating the example project and it looks good but i have doubts.

Is it possíble to make a different query to the database? Ex: show the data from a specific time ?

How can i see the code behind the "Library Control - SQL Table" Genie?

Thanks a lot

Hi Joao
I agree that the "DataBaseExchange" ActiveX control that ships with the product is due for a refresh, it is starting to look very dated.
I assume there would be some Microsoft built and maintained ActiveX controls out there that might also do the trick, but haven't personally used any lately. Perhaps check out the Citect Toolbox to see if anyone has posted something here:
https://softwareforums.aveva.com/citect_community/cit-toolbox/

With regards to the Library Control - SQL Table Genie, it might take a little time to dig through the cicode and could be difficult to modify it heavily to meet your requirements. But take a look at the cicode file _Internal_SqlTable.ci in the Library_Controls include project. Please note that modifying system include projects is not recommended, as any changes made are lost on upgrade and you don't get bug fixes.

Wishing you the best with your project.
Kind regards
Olivier

Hello Olivier…

Already developed a good tool based on Example project > DatabaseAccess and DatabaseDisplay pages, SQL Table control.
I am satisfied.

Thanks a lot

Regards