Reply from horatiusx on Nov 17 at 10:58 AM Hi handsome1234
the proposed corrections are in old style ABAP.
The error you are getting is because in ABAP 7.4 if you write a select and use commas in field list, then you have to escape ABAP variables with @
Moreover, in SUM and AVG you have to put spaces between field names and brackets.
This is the working version of your code:
TABLES SBOOK.
DATA: AACOUNT TYPE I,AASUM TYPE P DECIMALS 2,AAAVG TYPE F.
DATA: CONNID LIKE SBOOK-CONNID.
SELECT CONNID, COUNT(*), SUM( LUGGWEIGHT ), AVG( LUGGWEIGHT ) INTO (@CONNID, @AACOUNT, @AASUM, @AAAVG)
FROM SBOOK
WHERE
CARRID = 'LH' AND FLDATE = '19590228'
GROUP BY CONNID.
WRITE: / CONNID,AACOUNT,AASUM,AAAVG.
CHECK AASUM > 10.
WRITE: / ' THE SUM WEITHT>10'.
ENDSELECT.
| | | ---------------Original Message---------------
From: handsome1234
Sent: Wednesday, November 15, 2017 7:21 AM
Subject: Report this Error: If the new Open SQL Syntax is used, it Must be used Throughout
Simple code get error :report this error:
If the new Open SQL syntax is used, it must be used throughout. This includes using @ to escape host variables.
code:
TABLES SBOOK.
DATA: AACOUNT TYPE I,AASUM TYPE P DECIMALS 2,AAAVG TYPE F.
DATA: CONNID LIKE SBOOK-CONNID.
SELECT CONNID, COUNT(*), SUM(LUGGWEIGHT), AVG(LUGGWEIGHT) INTO (CONNID,AACOUNT,AASUM,AAAVG)
FROM SBOOK
WHERE
CARRID = 'LH' AND FLDATE = '19590228'
GROUP BY CONNID.
WRITE: / CONNID,AACOUNT,AASUM,AAAVG.
CHECK AASUM > 10.
WRITE: / ' THE SUM WEITHT>10'.
ENDSELECT . |
| Reply to this email to post your response. __.____._ |   _.____.__ |
