Where's revolver?
>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
>
--sb--
