topic Re: Dump DBIF_RSQL_INVALID_CURSOR in Application Development and Automation Discussions

Dump DBIF_RSQL_INVALID_CURSOR

Former Member — Tue, 27 Apr 2010 08:15:10 GMT

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

Re: Dump DBIF_RSQL_INVALID_CURSOR

Former Member — Tue, 27 Apr 2010 08:28:03 GMT

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

Re: Dump DBIF_RSQL_INVALID_CURSOR

Former Member — Tue, 27 Apr 2010 11:32:10 GMT

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