>Dear All
>
>RE:Problem Appended Records & Transactions with Local Views
>
>I have come across a problem when trying to update data using a local view. I want to insert several records in the view and then use nested transactions to modify the records before committing the new records to the base table. The problem is when I make the second change in the second transaction it scrambles the changes I made in the first level and causes a record out of range error. I have simplified the code below so that you can try it for yourself. Any help or explanation would be greatly appreciated.
>
Why do you need transactions before you update base table? It looks strange a little bit.