SQL

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

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