topic Re: Facing error in sql query. in Application Development and Automation Discussions

Facing error in sql query.

amysh95 — Tue, 19 Feb 2019 06:01:12 GMT

Hey,

am facing an error while writing sql query. I am using gui7.2.

error: If the new OpenSQL syntax is used, it must be used throughout. This includes using @ to escape host variables.

what is this. my code is:

SELECT SINGLE * FROM
ADRCT LEFT JOIN TVKO
ON ADDRNUMBER = TVKO-ADRNR
INTO ADRCT
WHERE TVKO-BUKRS = VBRK-BUKRS.

I also tried this.

SELECT SINGLE * FROM
ADRCT LEFT JOIN TVKO
ON ADDRNUMBER = TVKO-ADRNR
INTO (@ADRCT)
WHERE TVKO-BUKRS = VBRK-BUKRS.

but still facing error.

Sandra_Rossi — Tue, 19 Feb 2019 07:23:34 GMT

Don't use host expressions at all (don't use @) or use only host expressions (@ in front of all variables)

DoanManhQuynh — Tue, 19 Feb 2019 09:32:30 GMT

(@ADRCT) should be @ADRCT only, no bracket, where condition also need @.

Also, for join sql you have to use ~ instead of -.

matt — Tue, 19 Feb 2019 09:36:53 GMT

Read the ABAP help on the syntax of select.