Intouch Sql Clarification
- Thread starter AJMUL
- Start date
jshiepe
Member
When you install InTouch, make sure you install the SQL Access Manager. Once it is installed, review the SQL Access Manager's guide. A link should be found under Programs>Wonderware>Books. In short, you will need to:
1. Create a bind list
2. Open a connection to your database using SQLConnect statement(recommend doing this in a startup script)
3. Define a "where" expression(a criteria statement for your query if needed)
4. Use a SQLSelect statement to query your database
5. Be sure to use a SQLEnd statement after every SQLSelect to release allocated memory.
6. Be sure to include a SQLDisconnect statement in your shutdown script.
You will need to review the manual to fully understand the steps I have outlined.
Good Luck,
Jeff
1. Create a bind list
2. Open a connection to your database using SQLConnect statement(recommend doing this in a startup script)
3. Define a "where" expression(a criteria statement for your query if needed)
4. Use a SQLSelect statement to query your database
5. Be sure to use a SQLEnd statement after every SQLSelect to release allocated memory.
6. Be sure to include a SQLDisconnect statement in your shutdown script.
You will need to review the manual to fully understand the steps I have outlined.
Good Luck,
Jeff
Similar Topics
Hi,
I have an intouch 9.5 project passing data to a MS SQL 2005, all good so far.
I want to upgrade my HMI project to 2014R2, and SQL to 2012, but...
I've tried following "Wonderware InTouch HMI Supplementary Components Guide" but the value from sql not appear on intouch runtime screen.
I...
Hi, I want to connect the Intouch and MS SQL Server. But now I cannot access the SQL Server into MS SQL Server, the message was showing Invalid...
I have a wonderware standalone HMI collecting process data from our production line. I am writing those values to a database in MySQL, though I...
Hello,
I have an Intouch application that I am using a Sql select script to retrieve information from a database...
