Hello gents, can industrial graphics be used to query a database? I don’t want to have to query through the cicode and want to run it on the industrial graphics editor directly. Is it possible?
Hello gents, can industrial graphics be used to query a database? I don’t want to have to query through the cicode and want to run it on the industrial graphics editor directly. Is it possible?
This doesn't answer your question directly, however, as another option, the native graphics builder has a tool called Database Exchange. This can show/edit/query a database in a grid view.
Hi William,
There is no native grid control offered with Plant SCADA's Industrial Graphics to nicely display results etc.
I've never actually done this but I guess you could write a script to make a connection and execute a command. e.g.
dim myConn as System.Data.SqlClient.SqlConnection; dim myCommand as System.Data.SqlClient.SqlCommand; dim mySQLReader as System.Data.SqlClient.SqlDataReader; myConn = new System.Data.SqlClient.SqlConnection("add connectionstring here"); myConn.Open(); myCommand = new System.Data.SqlClient.SqlCommand("SELECT TOP 10 FROM things", myConn); mySQLReader = myCommand.ExecuteReader(); while(mySQLReader.Read()) { ... }
However, I don't have advice on whether it actually works, error handling or responsiveness or how to display the results.