• Replies 2 replies
  • Subscribers 581 subscribers
  • Views 200 views
  • Users 0 members are here
Options
Related

Operator Actions in SQL Database

StolzEnter

Hello,

I am trying to store operator actions in SQL database by assigning LOG Device in devices as SQL.

I am succeeded to log it in TEXT file as log device.
My query is.

1.How to configure SQL for this.I have created SQL Database 

2.What is the scripting part for logging in SQL ?

Or is any other way to do this..

Thanks.

Parents

  • Im not 100%, but I'm pretty sure the sql devices are really only for DBF's as there is nowhere to configure the connection string to connect to an external sql server. Using the inbuilt log functionalily is pretty limited, especially for capturing setpoint changes.

    If you want to log to an sql table, you'll need to write functions to do It for you. Ie using the functions: sqlconnect, sqlexec (or sqlset and  sqlappend, then sqlexec) and sqldisconnect

Reply

  • Im not 100%, but I'm pretty sure the sql devices are really only for DBF's as there is nowhere to configure the connection string to connect to an external sql server. Using the inbuilt log functionalily is pretty limited, especially for capturing setpoint changes.

    If you want to log to an sql table, you'll need to write functions to do It for you. Ie using the functions: sqlconnect, sqlexec (or sqlset and  sqlappend, then sqlexec) and sqldisconnect

Children
No Data
© 2025 AVEVA Group Limited or its subsidiaries. All Rights Reserved.