cancel
Showing results for 
Search instead for 
Did you mean: 

syntax error for authorization template

0 Kudos
144

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?

Accepted Solutions (0)

Answers (0)