Skip to Content
Jun 26, 2009 at 02:22 PM

database consistency INSERT and UPDATE


Hello all,

I have the following FORM:

FORM save_data

.... ...

INSERT z_table1.


  • find some info *****


UPDATE z_table2 SET ... WHERE ...


ENDFORM. "save_data

When running this code, apparently it is has happened the following:

After performing the "INSERT z_table1" the network connection to the SAP server was lost and the "UPDATE z_table2" was not performed.

Since after an INSERT the system always performs COMMIT, the result is a logical inconsistency because z_table2 was not UPDATEd.

¿How can I avoid this situation to happen again in the future?

Thank you.