AnsweredAssumed Answered

I keep getting this error  Incorrect syntax near '?'  when am trying to create a single query tag

Question asked by OscarTorres on Apr 7, 2017
Latest reply on Apr 7, 2017 by lmurphy

Do you know what this error refers to?

I created the query in there then I copied it in the tag exdesc column as 

/SQL="SELECT DefEsc_Hora, DecEsc_Cantidad,0

FROM [SIMODDE].[dbo].[pro_DefEscantillon]

WHERE {fn TIMESTAMPADD(SQL_TSI_SECOND,DefEsc_Hora,'1970-01-01 00:00:00')} > ? ORDER BY DefEsc_Hora DESC; " P1=TS

DefEsc_Hora is DateTime type and  DecEsc_Cantidad is Real type just how the manual says.

ErrorSQL.JPG

I just tried to fix it as the next image..

ErrorSQL-Manual.JPG

The Log says the following...

ErrorSQL-Log.jpeg

 

Any help would be appreciated

 

 

 

Outcomes