>The one(s) appended is what I'm looking for. The deleted one(s) are not imported. One the appended records I have to let go a function. So I SEEK the first record for a client and want to use a DO WHILE...ENDDO. But can't do this, it crashes.
>
>Can u motivate why using a transaction is not the way to go?
Maybe, maybe not :)
Generally, you want transactions to be as quick...every record involved in the transaction becomes locked for the duration of the transaction. Maybe this is not a problem for what you are trying to do.
When you wrap it in a transaction, and issue multiple tableupdates, does your SEEK work properly? Do you have a working solution?
Steve Gibson