Hi Pedro,

What version of VFP?

SP1 for VFP8 has a fix saying: "• SQL - UPDATE and DELETE are not Rushmore-optimized if target table has table buffered changes.".

Sounds similar to me.

good luck


>Hi all :
>
>My invoice program is taking forever to do the tableupdate() to the view.
>
>Sometimes an invoice was 50 lines or more of itens , and for each item its requerid to make a lot of changes in the views.
>
>The problem is that when issuing TABLEUPDATE(.t.) (buffering = 5) I can go take a coffe (literaly).
>
>Solutions someone?
>
>TIA