topic Re: ABAP 7.40 question SELECT in Application Development and Automation Discussions

ABAP 7.40 question SELECT

ralf_wenzel_heuristika — Thu, 29 Oct 2015 19:38:38 GMT

Hi,

in our system, the command

SELECT SINGLE 'X'

INTO DATA(exists) FROM dbtab

WHERE ....

does not work. Is this SP8 specific? We do have SP5.

I want to use this, because this existence indicator won't ne used in further coding.

christian102094 — Thu, 29 Oct 2015 20:08:14 GMT

When you use a inline declaration ( DATA(exists) ), you have to escape the program variables with '@':

SELECT SINGLE 'X'

INTO @DATA(exists) FROM dbtab

WHERE ....

Don't forget if you have some variables (that were declared in your program) in the condition clause WHERE, you have to escape them too.

ralf_wenzel_heuristika — Thu, 29 Oct 2015 20:28:36 GMT

ooops, I tried DATA(exists) and DATA(@exists), but not @DATA(exists)

I tried it now, but it does not work (in SP5).

christian102094 — Thu, 29 Oct 2015 20:31:43 GMT

What's the error message? Please post all the relevant information about the error you are getting.

ralf_wenzel_heuristika — Fri, 30 Oct 2015 10:00:03 GMT

The error message said, that offset is not allowed in new OpenSQL syntax. The parser seems to "think", hat (...) is a variable for the offset