topic Re: Native SQL Issue. in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/native-sql-issue/m-p/6375737#M1402621 <HTML><HEAD></HEAD><BODY><P>I solved the problem by adding 'WAIT' ABAP statement.</P></BODY></HTML> Tue, 17 Nov 2009 20:26:04 GMT Former Member 2009-11-17T20:26:04Z Native SQL Issue. https://community.sap.com/t5/application-development-and-automation-discussions/native-sql-issue/m-p/6375735#M1402619 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I am doing a EXEC SQL/ENDEXEC Native SQL Call from within my ABAP program to insert records into an SQL Server database. </P><P></P><P>The EXEC SQL/ENDEXEC is within a loop and I am trying to insert rougly 200+ records from my abap program into the sql server table.</P><P></P><P>What I am noticing is that when I step through my logic, the insert happen as they should. When there is no break point and the program runs, inserts into the sql server table do not occur.</P><P></P><P>I am a little baffled and wanted to find out if any of you all have had this kind of a issue and how it was solved.</P><P></P><P>I was thinking of putting a WAIT abap statement kind of like a timer.</P><P></P><P>Any guidence or suggestions?</P><P></P><P>Regards,</P><P></P><P>Salil</P></BODY></HTML> Tue, 17 Nov 2009 16:00:09 GMT https://community.sap.com/t5/application-development-and-automation-discussions/native-sql-issue/m-p/6375735#M1402619 Former Member 2009-11-17T16:00:09Z Re: Native SQL Issue. https://community.sap.com/t5/application-development-and-automation-discussions/native-sql-issue/m-p/6375736#M1402620 <HTML><HEAD></HEAD><BODY><P>Try commit.</P><P></P><P></P><P></P><P>Ariel Fisher</P></BODY></HTML> Tue, 17 Nov 2009 17:38:52 GMT https://community.sap.com/t5/application-development-and-automation-discussions/native-sql-issue/m-p/6375736#M1402620 former_member195999 2009-11-17T17:38:52Z Re: Native SQL Issue. https://community.sap.com/t5/application-development-and-automation-discussions/native-sql-issue/m-p/6375737#M1402621 <HTML><HEAD></HEAD><BODY><P>I solved the problem by adding 'WAIT' ABAP statement.</P></BODY></HTML> Tue, 17 Nov 2009 20:26:04 GMT https://community.sap.com/t5/application-development-and-automation-discussions/native-sql-issue/m-p/6375737#M1402621 Former Member 2009-11-17T20:26:04Z