I have some code which allows for backing out updates. It starts off with a DBEngine.BeginTrans and end with either a DBEngine.CommitTrans or DBEngine.Rollback depending upon the user.
This has been working great for 99% of my needs. I can't claim the praise for this as I got it off a thread here.
Where I'm getting stuck is as follows.
I want to insert a record into a table and directly after update it. The reason I'm doing this is one of the fields is for the insert is NULL on the form until I actually get the ID for the inserted record. So any ideas how I can update a record that hasn't yet been committed?
This has been working great for 99% of my needs. I can't claim the praise for this as I got it off a thread here.
Where I'm getting stuck is as follows.
I want to insert a record into a table and directly after update it. The reason I'm doing this is one of the fields is for the insert is NULL on the form until I actually get the ID for the inserted record. So any ideas how I can update a record that hasn't yet been committed?