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