topic Re: Open Cursor - Deleting. in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/open-cursor-deleting/m-p/3900360#M935940 <HTML><HEAD></HEAD><BODY><P>you should not use a cursor to do that</P><P></P><P>at least you should not open a cursor in a LOOP as you do !</P></BODY></HTML> Wed, 28 May 2008 09:47:30 GMT franois_henrotte 2008-05-28T09:47:30Z Open Cursor - Deleting. https://community.sap.com/t5/application-development-and-automation-discussions/open-cursor-deleting/m-p/3900359#M935939 <HTML><HEAD></HEAD><BODY><P>Hi there , Guys could you help with the following plz:</P><P></P><P> LOOP AT ti_ref.</P><P></P><P> OPEN CURSOR WITH HOLD cursor1 FOR</P><P> SELECT * FROM erch</P><P> WHERE belnr = ti_ref-ref</P><P> and intopbel = '' .</P><P> if sy-subrc </P><P> DO.</P><P> </P><UL><LI level="1" type="ul"><P>" I want to erase register found from ti_ref*</P></LI></UL><P> </P><UL><LI level="1" type="ul"><P>" How Can I do that ???*</P></LI></UL><P> PACKAGE SIZE p_commit.</P><P> IF sy-subrc NE '0'.</P><P> CLOSE CURSOR cursor1.</P><P> EXIT.</P><P> ENDIF.</P><P> ENDDO.</P><P></P><P> ENDLOOP.</P></BODY></HTML> Wed, 28 May 2008 09:42:49 GMT https://community.sap.com/t5/application-development-and-automation-discussions/open-cursor-deleting/m-p/3900359#M935939 Former Member 2008-05-28T09:42:49Z Re: Open Cursor - Deleting. https://community.sap.com/t5/application-development-and-automation-discussions/open-cursor-deleting/m-p/3900360#M935940 <HTML><HEAD></HEAD><BODY><P>you should not use a cursor to do that</P><P></P><P>at least you should not open a cursor in a LOOP as you do !</P></BODY></HTML> Wed, 28 May 2008 09:47:30 GMT https://community.sap.com/t5/application-development-and-automation-discussions/open-cursor-deleting/m-p/3900360#M935940 franois_henrotte 2008-05-28T09:47:30Z