Hello,
Ignition 8.1.26, Vision, window, Numeric Text Box, bound to a SQL Query. Per this screen shot, attached pic, when the user invokes this form, it is often coming up 'red' with this 'broken link' error. All data seems to be valid.
It is a Numeric Text Box in the pic to the left of this, also bound to a SQL query that has never had this problem. I was suspecting a performance, not reading the data in time problem, but why don't most of the other SQL bound text boxes on the form have this problem. Both SQL queries, labeled good/bad are noted below. Should I use a Named Query instead. Any ideas for troubleshooting? Thanks.
Problem:
SELECT [Billet Length (IN)]
FROM FurnaceSetup
WHERE DieID = '{Root Container.ContainerRecipe.DieID.selectedStringValue}' And
Copy = {Root Container.ContainerRecipe.Copy.intValue} And
Alloy = '{Root Container.ContainerRecipe.Alloy.text}'
No problems:
SELECT BilletLength
FROM Production
WHERE RunID = {Root Container.RunID}