Skip to Content
0

Syntax Error if i try to start my hana query in Crystal Reports with any command except SELECT

Feb 15 at 08:19 AM

19

avatar image
Former Member

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,

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

0 Answers