Re: Question on Multi-Table Inserts

On 16/04/2013 11:59, Don Parris wrote:
[snip]

> Is it as simple as running a series of insert statements in succession,
> passing on the PK of the first table to the next table in the process?
> I.e.,
>
> BEGIN
> INSERT into table payee(values...)
> INSERT into table transrec(values...) # pass in payee_id variable
> SELECT *from category (to get cat_id)
> INSERT into table transdetails(values...) #pass in transrec_id and
> cat_id variables
> COMMIT
>
> Or is it more complicated than that?

If your only data store is the database then using a transaction is the
right thing to do. Being all-or-nothing you get exactly what you want.

federico