AnsweredAssumed Answered

PI RDBMS query will not execute

Question asked by caffreys_col on Jul 18, 2017
Latest reply on Jul 19, 2017 by caffreys_col

Hi Everyone,


Hopefully an easy answer to this one...


I'm setting up a PI-RDBMS interface and the query I have been given from a sister site will not execute. The query is in the screenshot below. When I run it as a standalone query in SQL it has an issue with the "where timepackedtime>?" clause; it doesn't like the "?". I can change the "?" to a timestamp (2017-7-1) and the query works fine, but with the ? it fails. We tested the interface several years ago and we had resolved this issue at that time but unfortunately the interface was removed from service and the "modified" query has been lost.

As usual, any help greatly appreciated.