>1) You don't mention if you are checking the return value from TABLEUPDATE() -- is it returning .T. or .F.?

No, I don't check this value. I will add a check just to see...

>
>2) When you say "saves merchandise table", do you mean that you're trying to do the same sort of BEGIN TRANSACTION/TABLEUPDATE()/END TRANSACTION routine? Do you explicitly select the merchandise table before doing the update?

Yes, but in this case, the warehouse table is not touched...