topic Error: Invalid interruption of a database selection in Application Development and Automation Discussions

Error: Invalid interruption of a database selection

Former Member — Mon, 04 Jun 2007 07:45:55 GMT

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.

Re: Error: Invalid interruption of a database selection

Former Member — Mon, 04 Jun 2007 07:50:10 GMT

u cannt debug SELECT-ENDSELECT.

Regards

Peram

Re: Error: Invalid interruption of a database selection

dev_parbutteea — Mon, 04 Jun 2007 07:59:45 GMT

Hi,

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

Regards,

Sooness

Re: Error: Invalid interruption of a database selection

Former Member — Mon, 04 Jun 2007 08:01:31 GMT

HI,

you cannot put break point inside SELECT and ENDSELECT.

Because system will miss the cursor index.

Regards,

Naveen

Re: Error: Invalid interruption of a database selection

Former Member — Mon, 04 Jun 2007 08:04:36 GMT

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....

Re: Error: Invalid interruption of a database selection

Former Member — Mon, 04 Jun 2007 08:06:59 GMT

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

Re: Error: Invalid interruption of a database selection

uwe_schieferstein — Mon, 04 Jun 2007 08:08:47 GMT

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