Page 1 of 1

insert (update) several tables simultaneously?

Posted: Thu Jun 28, 2012 2:46 am
by wvoyance
I have 3 tables, and is going to insert one new record.
The first table might be succeeded, but the second or the third one failed.
That will cause problem, for half done.
I want either all succeeded or none.

How can I do that, except by writing a complicate program to check before insertion?

The same question for update.

Re: insert (update) several tables simultaneously?

Posted: Thu Jun 28, 2012 3:06 am
by requinix