here is my scenario:
- I have an entry screen, where an Operator requests to download a recipe (Entity “E1”)
- “E1” sends a request to SQL Server to prepare the recipe (Entity “E2” a SP on SQL Server)
- “E2” prepares the recipe data and sets it in a table for Wonderware to download (Entity “E3”)
- “E3” Currently has a script that keeps polling the table to find out if data is available for it at a 2” interval.
What I am trying to obtain is this:
- “E1” sends the request to SQL Server to prepare the recipe (Entity “E2”)
- “E2” prepares the recipe data and sets it in a table for Wonderware to download (Entity “E3”)
- “E2” sets a value in a specific Field Attribute of “E3” named (BoolRecipeAvailable) to true, (maybe call a DLL to do it?)
- “E3” has a script that gets activated by BoolRecipeAvailable going to True or on a DataChange.
I have a Wonderware toolkit that can read/write inside a running Galaxy. How can I call one of its methods from the SQL Server stored procedure that prepares the requested data? This would allow me to use the DataChange or OnTrue events to start the script performing the download, without having to be time-activated.
Anyone ever ran into a similar situation? Thank you,
Marco
The current system has a script that every 2" queries a SQL table to check if there is data prepared for it, but due to the fact that 'When' is determined by the operator, most of this script runs are useless.