Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Russian Roulette
Message
From
04/05/2005 16:01:41
 
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:
01011027
Views:
18
>Where's revolver?
>
In the customer's hand :-)

>>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
>>
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform