>It reduced under 1 second... I guess good ol' traditional ways are faster.
>Thanks again!
Hi Alex,
It depends on what you're doing and what VFP version you're using. In VFP9 you can do
UPDATE bom ;
SET itemvalue = TBOMUPDATE.itemvalue, ;
...
SET itemcost = TBOMUPDATE.itemcost ;
FROM bom ;
JOIN TBOMUPDATE ON bom.bom_pk = TBOMUPDATE.bom_pk
--sb--