Sometimes get 'broken' SQL binding on Vision window Numeric Text Box

Ignition
, ,
1

Untitled
Untitled454×1008 34.2 KB

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}

2

In designer when it is showing as Error, right click the control and select Diagnostics.
This will show the cause of the error.

3

You are using string substitution to supply parameters to your query. Curly braces in standard SQL queries perform brainless (and dangerous) string conversion and insertion. Any character in your alloy text that doesn't behave in the quoted string will break that SQL and permit security hacking of your database. (AKA SQL Injection.)

Convert to a named query and use value parameters. Then turn off legacy DB permissions in the project properties so no-one re-introduces this security hazard.

4

OK. Thank you.