Skip to Content
0
May 17, 2018 at 04:56 PM

syntax error for authorization template

75 Views

Hi,

This is my first authorization template, the authorization must load when the following query is executed:

SELECT DISTINCT 'TRUE' FROM ORDR T0 WHERE T0.[DocNum] = $[ORDR.DocNum] AND T0.[Series] = $[ORDR.Series]

But the query gives me

1). [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near 'ORDR.DocNum'.
2). [Microsoft][SQL Server Native Client 11.0][SQL Server]Statement 'Queries' (OUQR) (s) could not be prepared.

Same thing for Series, what am I doing wrong?