I am trying to bind an opc tag path to a customer property dynamically by calling a stored procedure that builds the path.
the entry below in an expression for the property works:
My query builds the exact same path.
I tried just putting the select statement in a sql query for the binding but the syntax of creating the script causes an issue with java syntax because I have to add +’}’ to the end of the final select statement.
I then tried just calling it from a stored procedure call in the sql query and returns exactly what I want, but it does not treat path returned as the binded value but just text in that field:
So I assume I need to call the stored procedure in an expression for the binding of that property for it treat the returned opc path as the binded value?
So I now I am trying to figure out how to call the stored procedure in the expression. I have seen a few entries about using executeQuery, etc… but when I attempt that in an expression, it treats executeQuery as an unknown function.
executeQuery("exec sp_GetHVPortConfigByIPIA ")
Beyond that, I don’t see how I direct it to a specific connection source in the expression, which means I am missing the point entirely on calling sql from an expression as a whole. Gets back to my lacking java exposure.
Sorry for long post, any pointers or links I can read up on specifically to expresions would be greatly appreciated.