Skip to Content
0

syntax error for authorization template

May 17 at 04:56 PM

35

avatar image

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?

SQL
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers