I need to insert new records into 2 or more tables.<BR>I want them to be both inserted, or neither inserted if an error occurs.<BR>I believe a "transaction" is what I need.<BR><BR>I can insert the rows in one of two ways,<BR>either I can build the rows in a dataset, and then execute an UPDATE.<BR>OR I can just do a "begin transaction", execute a SQL INSERT for table 1,<BR>and then execute a SQL INSERT for table 2 and then do a "transaction commit"<BR><BR>My question is this, do I still need to do a transaction if I&#039;m doing it the dataset way?<BR>Does the dataset UPDATE automatically start a transaction?<BR><BR>Do I need to nest the dataset UPDATEs within a tranaction in code?<BR><BR>Tom Maiden