06-21-2007 6:45 AM
06-21-2007 6:47 AM
Because you try to debug the SQL command which is not uspported by ABAP debugger.
Reward points if useful.
Regards,
Atish
06-21-2007 6:50 AM
Hi Kotireddy ,
The reason for it is given in the help for select statement .
Here is the reason specified.
<b>If a SELECT - ENDSELECT loop contains a statement that triggers a database commit, the cursor belonging to the loop is lost and a program termination and runtime error occur. Remote Function Calls and changes of screen always lead to a database commit.</b>
Hope this helps.
Regards
Arun
06-21-2007 6:52 AM
Hi Koti,
1.when the specified value not exist in the table ( where condition value)
2.even when u try to fetch huge records from database....it may goto shortdump...
3.datatype mismatch....
4. when INTO CORRESPONDING not used....
Regards..
Balaji ( assign points if this helps u ...)
06-21-2007 6:54 AM
Don't try to debugg the select st.
u can check sy-subrc or internal tables...
06-21-2007 6:56 AM
Hi koti,
I like to add one more point...
when a breakpoint is applied at select loops can cause an exception thru loss of databse cursor. The reason for this is that during debugging a database commit is triggered and cursor is lost...
Regards.
Balaji ( assign points if this helps u ....)