A simple test in order to understand the VFP9's UPDATE.
CREATE CURSOR aaa ( f1 i , f2 i)
INSERT INTO AAA (F1,F2) VALUES (1,2)
INSERT INTO AAA (F1,F2) VALUES (3,4)
UPDATE AAA SET F1=X.F2,F2=X.F1 FROM AAA X
BROWSE
CREATE CURSOR aaa ( f1 i , f2 i)
INSERT INTO AAA (F1,F2) VALUES (1,2)
INSERT INTO AAA (F1,F2) VALUES (3,4)
UPDATE AAA SET F1=X.F2,F2=X.F1 FROM AAA X WHERE X.F1=1
BROWSE
CREATE CURSOR aaa ( f1 i , f2 i)
INSERT INTO AAA (F1,F2) VALUES (1,2)
INSERT INTO AAA (F1,F2) VALUES (3,4)
UPDATE AAA SET F1=X.F2,F2=X.F1 FROM AAA X WHERE X.F1=3
BROWSE
