on 2018 May 17 5:56 PM
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?
User | Count |
---|---|
112 | |
9 | |
8 | |
6 | |
5 | |
5 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.