Hello,
I'm trying to update some values in my Database via SQL Update named query pulling data from a Table Component.
The "submit" button runs the Update query and correctly uploads the data to the database (Checked both from the SQL Management Studio and by running the "Select" Named Query that populates the table fields in the Designer.) but if I do so from the "refresh" button I don't see updated data but a version that's "old" by an order of minutes UNLESS it's the first "Update" that is done on the table (Either via Named Query or by directly editing the Table data) in a while.
The script is correctly running and the issue lies in the "Query" results themselves (I have made sure by just shoving the query results directly into a test variable and it's not a matter of transitioning the data into the Table but of the query results themselves)
Is there any kind of timeout regarding to data updates of which I am unaware? Don't exclude dumb solutions\mistakes which I may have forgotten to consider as I am quite new to SCADA\Database interactions.
