>Hi all
> A simple question ?
>
>

     sele stockout
>     replace ** with ***
>     begin transaction
>     lnoerror = tableupdate(.F.,.T.)
>*     if lnoerror <b>&& don't need this: = .T.</b>
>         sele items
>         replace ..... with .....
>         lnoerror = <b>lNoError and</b> tableupdate(.F.,.T.)
>*     endif
>*     if lnoerror <b>&& don't need this: = .T.</b>
>         sele invoice
>         replace .... with ......
>         lnoerror = <b>lNoError and</b> tableupdate(.F.,.T.)
>*     endif
>*     if lnoerror <b>&& don't need this: = .T.</b>
>        sele debtor
>        replace ...... with .......
>        lnoerror = <b>lNoError and</b> tableupdate(.F.,.T.)
>*     endif
>     if lnoerror = .F.
>         RollBack
>     else
>         end transaction
>     endif

>if debtor can't update, will rollback revert stockout, invoice, items tables ?

Yes, that's how VFP works. I've added a few suggestions in code above. Actually, you don't have to check for lNoError each time, because the final test will roll them all back, or commit the whole transaction. Just trying to have as little code inside transaction as possible, because it's recommended that you should it the shortest you can. While transaction is in progress, locks are applied and held on all the affected records.