You're welcome...from this humble foxpro programmer from New Mexico, US :)
That seems to follow. My code example was how I'd approach the original bit of code you posted.

The general point is that you only END TRANSACTION if the transaction can be successfully (if the tables are updated). Otherwise, you ROLLBACK the transaction. Then you're left with the problem of what to do with the data in the buffers.

>thanks for helping this humble foxpro programmer from holland,
>
>so the routine woult then be
>
>if !succes
>rollback
>for each atables in thisform.atables
>tablerevert(.t.,atables)
>endfor
>
>david
>
>ps thanks for helping me out