Forum Discussion
Do input tag values keep updating after SP execution begins?
In my facility we use PLC's to trigger SQL Stored Procedures through a Kepware server. Most of these SP's are for data collection.
If I set the execute bit to true, but then one of my data collection points changes value before the execution finishes, does the SP see that data change? Or is it just using the value as it was at time of execution start?
Thanks for your help in advance
2 Replies
Hello friend.
All I know is when the stored procedure executes it queries the database at that very precise time.
Take care.
Not knowing how your stored procedure looks, how kepware server works, nor how your collection points presents data to queries, this is difficult to impossible to answer.
The most accurate answer that can be given is "it depends".
Your procedure could loop through collection points, fetching data according to when that collection point's data is written to SQL Server.
It could be that data is buffered on the collection point or by kepware, and only a specified data point is written to SQL Server.
Or it could be that data is buffered and all buffered data points are ingested to SQL server.
