Error: Invalid interruption of a database selection

[Former Member]

Hi,

When i execute the below code, the output is displayed without any problem.

<b>tables lfa1.

select * from lfa1 order by lifnr.

write / lfa1-lifnr.

endselect.</b>

But however when i debug this piece of code, i get an error as below.

ShrtText - Invalid interruption of a database selection

Runtime Errors - DBIF_RSQL_INVALID_CURSOR

Exceptn - CX_SY_OPEN_SQL_DB

Can anybody help me with the reason for the occurence of this problem.

[Former Member]

u cannt debug SELECT-ENDSELECT.

Regards

Peram

[dev_parbutteea]

Hi,

select .. endselect. dumps the first time only when in debugging mode!

Regards,

Sooness

[Former Member]

HI,

you cannot put break point inside SELECT and ENDSELECT.

Because system will miss the cursor index.

Regards,

Naveen

[Former Member]

Hi

The reason may be You put a break-point between SELECT and ENDSELECT..It will always gives you a Shortdump because you are trying to interrupt an SQL statement. Take out the Breakpoint from the middle of select endselect and try it somewhere else in the program. This time your debugger will work perfectly.Otherwise if you want to use Debugger in between the Select and Endselect use it after an appending.

Reward All Helpfull answers....

[Former Member]

Hi Vijay,

Just go through the following link:

As Sooness pointed out, SELECT-ENDSELECT dumps only the first time. Try re-executing it and it will work fine.

Meanwhile, it is always better to use INTO TABLE OF instead of SELECT-ENDSELECT, as this minimizes database hits.

Regards

Anil Madhavan

[uwe_schieferstein]

Hello Vijay

You can debug a SELECT - ENDSELECT loop but you have to use <b>F6 </b>(and not F5) for step-by-step debugging.

Regards

Uwe