Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Russian Roulette
Message
 
 
To
04/05/2005 09:52:57
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
Miscellaneous
Thread ID:
01010750
Message ID:
01010932
Views:
36
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--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform