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

database consistency INSERT and UPDATE

15 Views

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.