topic Re: About Select Query in Application Development and Automation Discussions

About Select Query

Former Member — Wed, 25 Jan 2006 09:09:43 GMT

Dear Guru's

I just want to know the reason why ?

if I place my break point in the code between select and endselect, it throws a dump ?

Regards,

PAVAN.

Re: About Select Query

Former Member — Wed, 25 Jan 2006 09:11:56 GMT

I hope it may not be the case.

Placing breakpoints may surely not produce dumps.

Re: About Select Query

Former Member — Wed, 25 Jan 2006 09:13:44 GMT

more detail would allow help.

Re: About Select Query

Former Member — Wed, 25 Jan 2006 09:17:15 GMT

Hi Pavan,

I have seen the same thing many times.I don't know why but f5 at select-endselect sometimes gives us a dump.

I'll wait with you for the answer.

Re: About Select Query

Former Member — Wed, 25 Jan 2006 09:49:31 GMT

A breakpoint in SELECT loops can cause an exception through loss of the database cursor. The reason for this is that - during debugging - a database Commit is triggered.

See <a href="http://www.sapfans.com/forums/viewtopic.php?t=169464&highlight=&sid=418f3ccc51dca0f3cc982e5d04107cb7">Debug mode</a> for more details.

Ps: Reward points if helpful.

Re: About Select Query

Former Member — Wed, 25 Jan 2006 10:00:07 GMT

Hi Wen ,

Thanks for Ur kind response ..

Can U Plz explain it in detail

Regards,

PAVAN..

Re: About Select Query

Former Member — Wed, 25 Jan 2006 10:09:49 GMT

It may be because commit work is not getting executed implictly in debugger. A database commit can occur while debugging.

The most important is that all database changes must be rolled back in the event of a program termination. To ensure that this is possible, a dialog process converts to a debugging process when a user wants to work with the Debugger. This process is assigned to the user for the duration of their debugging session.

Re: About Select Query

Former Member — Wed, 25 Jan 2006 10:34:32 GMT

Hi Wen,

Thanks for Ur great response..

Hi Ravi,

I think this is Useful for us ..

Regards,

PAVAN..

Message was edited by: Pavan Satya