manasi
Member
Hello All
how to compare SQL table's columns in InTouch and reflects result in InTouch Tag to start logging in another SQL table...
1. I have two different tables in SQL DB, Master table and Child table.
2. I have two compare two columns in Master Table i.e Product ID column and Status column. On Production start command receipt from InTouch app. (using Toggle button in Wonderware InTouch)
3. After the receipt of production start command from Wonderware, need to write a InTouch SQL script that will compare the columns of Master table mentioned above.
4. If there is a "NEW" text present in the status column against that times ProductionID then only start logging InTouch Tag (Product Temperature) in Child table created in SQL DB under temperature column.
Please HELP...
Manasi
how to compare SQL table's columns in InTouch and reflects result in InTouch Tag to start logging in another SQL table...
1. I have two different tables in SQL DB, Master table and Child table.
2. I have two compare two columns in Master Table i.e Product ID column and Status column. On Production start command receipt from InTouch app. (using Toggle button in Wonderware InTouch)
3. After the receipt of production start command from Wonderware, need to write a InTouch SQL script that will compare the columns of Master table mentioned above.
4. If there is a "NEW" text present in the status column against that times ProductionID then only start logging InTouch Tag (Product Temperature) in Child table created in SQL DB under temperature column.
Please HELP...
Manasi