The younger brother in the MIS system, use PB + SQL development system is a multi-user, when documents preservation, because involves the document header, documents detail and need a purchasing plan of tracking the writing process, I save the document header, and then according to the data window detail write purchasing plan, finally saved the documents detail, now the problem is, why some documents save failed, document header and rolled back the details, but the purchasing plan but there was no rollback, headers and detail because it is directly with data Windows UPDATE, and have brought ResetUpdate, and procurement plan against writing are directly write SQL statements, and ultimately is to all three perform after a successful submission, please help me to analyze the reason, thank you!

CodePudding user response:

There is no answer

CodePudding user response:

Transaction control of incomplete, can add judgment, if save the document header is not successful, not to execute SQL statements

CodePudding user response:

0 1 ah

CodePudding user response:

rollback

CodePudding user response:

Forget the rollback

CodePudding user response:

The save failed after a rollback statement,

CodePudding user response:

up

CodePudding user response:

rollback

CodePudding user response:

I also want to know, thank you LZ.