Native SQL Issue.

[Former Member]

Hello,

I am doing a EXEC SQL/ENDEXEC Native SQL Call from within my ABAP program to insert records into an SQL Server database.

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.

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.

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.

I was thinking of putting a WAIT abap statement kind of like a timer.

Any guidence or suggestions?

Regards,

Salil

[former_member195999]

Try commit.

Ariel Fisher

[Former Member]

I solved the problem by adding 'WAIT' ABAP statement.