Citect Scada v7.4 report to SQL Server

Hello,

I am using Vijeo Citect version 7.40. I am working on reports as customers demand whenever they want to generate the report, just press the button and generate the report with previous data. That's why I need to connect it with an SQL server to store my data in the database. Anyone knows the proper steps how to connect to the SQL server.

Thank you

Parents

Jacky Lang over 2 years ago

I believe that there are a number of SQL Cicode functions available in v7.40, such as SQLCreate, SQLOpen, SQLClose, SQLDispose, SQLConnect, SQLDisconnect, SQLInfo, etc. Please refer to the online help for details. It is not recommended that a SQL application be executed on a server process or machine.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel

Reply

Jacky Lang over 2 years ago

I believe that there are a number of SQL Cicode functions available in v7.40, such as SQLCreate, SQLOpen, SQLClose, SQLDispose, SQLConnect, SQLDisconnect, SQLInfo, etc. Please refer to the online help for details. It is not recommended that a SQL application be executed on a server process or machine.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel

Children

Mehak Fatima over 2 years ago in reply to Jacky Lang

Do you have any idea how to create a time function?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
Jacky Lang over 2 years ago in reply to Mehak Fatima

Create a time-based event in your project and assign your Cicode function in Action Field.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel