MySQL Forums
Forum List  »  InnoDB

Re: cross-table business validation check at END of transaction
Posted by: Greg Hauptmann
Date: January 23, 2009 10:51PM

some additional clarification re my question:

So in summary my application would be issuing effectively the following things:
- start transaction
- change record A on Table X
- change record B on Table Y
- change record C on Table Y
- commit

So what I want to do is within the Database (e.g. stored procedure / trigger / whatever) is to be able to have some code that only triggers once all the record changes are in place, BUT before the final commit. That is, it'll only be at this point where the cross-table business rule would make sense to apply.

So my question is within the code for a mysql StoredProc or Trigger (or whatever), what would be the Function or Syntax that you would use to hook into this point?

Thanks

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: cross-table business validation check at END of transaction
2516
January 23, 2009 10:51PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.