How to use a OPC value to

Ignition
1

I am trying to refence a tag in my queries but I keep getting weird errors. Any help would be appericated
SELECT Built
FROM View_ActiveOrders
Where Targetlineid = 50 And Orderid ='[DT Right Hand]New Tag'
One of the errors
Conversion failed when converting the varchar value '[DT Right Hand]New Tag' to data type int.

2

That's a string and the data column appears (from the error) to be defined as an INT.

If this is in a script then please post some context so we know where [DT Right Hand]New Tag is supposed to be coming from.

Tip: Please format code in your posts.

Formatting code
Formatting code741×191 17.4 KB

3

I was using that in the Named Queries

4

The Tag I am using is a refence tag which is set up as an int

5

Please show us how. Make it easy for us to help you. Provide details as requested.

6 
SELECT Built
FROM View_ActiveOrders 
Where Targetlineid = 50 And Orderid = '[DT Right Hand]New Tag.value'
7

First, there's no way for SQL to tell that your string constant is supposed to be a tag. You need to use a value parameter. Then where you call the named query, you retrieve and supply the tag value to the parameter.

1 Like
8

That's not how this works.

You need to pass the tag's value to the the named query where you're calling it.
Use a parameter in your named query (it looks like this :parameter).

https://docs.inductiveautomation.com/display/DOC81/Named+Queries

9

I will give this a try thank you