Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Dump DBIF_RSQL_INVALID_CURSOR

Former Member
0 Kudos

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

1 ACCEPTED SOLUTION

former_member628395
Active Participant
0 Kudos

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

2 REPLIES 2

former_member628395
Active Participant
0 Kudos

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
0 Kudos

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