Dump DBIF_RSQL_INVALID_CURSOR

[Former Member]

Hi all

when i run the select statement, it's dump after 10 loops, why?

the code

  select * from zxxx_xxxxxx
           into wa_zxxxx_xxxxx
           where werk      in s_werks
           and (  masch1 eq pm_matyp
           or     masch2 eq pm_matyp
           or     masch3 eq pm_matyp )
           order by defplunr.
endselect.

thx

[Former Member]

Hi,

Why don't you use a select query with the INTO CORRESPONDING FIELD OF TABLE addition and then sort it as you want. Also

use IN instead of or when specifying the conditions using OR.

Regards,

Sagar

[Former Member]

Hi,

Why don't you use a select query with the INTO CORRESPONDING FIELD OF TABLE addition and then sort it as you want. Also

use IN instead of or when specifying the conditions using OR.

Regards,

Sagar

[Former Member]

How can you "order" the data...you're not storing it anywhere.