on 02-15-2018 8:19 AM
Dears Experts,
i face issue when i try to start my query in crystal reports with ( IF Statements, Declare Variables,...etc) except SELECT
For Example :
if i run the report with this query :
SELECT * FROM OINV T0
But if i run the reports with this query:
IF 1=1
THEN
SELECT * FROM OINV T0;
END IF;
it will give to me this error message:
Syntax error or access violation; 257 sql syntax error: incorrect syntax near "IF": line 1 col 1 (at pos 1) [Database Vendor Code:257]
Please note :
when i take the same query and execute it in SAP it returns data correctly.
Please advise,
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.