Skip to Content
avatar image
-3
Former Member

can we use for all entries along with case statement in new open sql 7.4

Hello Everyone,

When I tried to use case ..endcase and for all entries it throws an error saying " The addition or variable with ID "xxx" is not allowed in conjunction with FOR ALL ENTRIES." i want to develop this using new open sql 7.4 syntax.

sample code :

select counter,

case when raufnr = ' ' then

case when rnplnr = ' ' then ' ' else rnplnr end

else

raufnr
END AS proj_number

FROM catsdb
INTO TABLE @lt_cats
FOR ALL ENTRIES IN @lt_refcounters
WHERE counter = @lt_refcounters-refcounter.

can some body let me know what the issue is.Thanks...

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 23, 2016 at 07:43 AM
    Add comment
    10|10000 characters needed characters exceeded