Skip to Content

syntax error for authorization template

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers