Simulate Transaction

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Basically I have one task I need to complete successfully before another one
is attempted.

I update one record in one table with information. I then need to insert or
update multiple rows into another table based on the items selected in a
listbox with multiple selection enabled.

Here is a good example:

User information with 5 fields in table A.
Update any fields that changed.

Table b is the groups user is a member of. The admin can select or remove
any groups the user is a member of. In table b there is a row for each group
the user is a member of.
UserID GroupID

I will need to enumerate the items in an arraylist and based on the item
value update or insert into table b. However, this can only occur if the
table A update completed successfully.

Any ideas.

Thanks
 
Instead of simulating a transaction, why not use an actual transaction?

What is it that you are asking?
 
Back
Top