On Tue, Apr 16, 2013 at 8:54 AM, Federico Di Gregorio <fog@dndg.it> wrote:
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