Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL quest
Message
From
31/07/2001 17:04:45
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00538004
Message ID:
00538026
Views:
11
This message has been marked as a message which has helped to the initial question of the thread.
>In vfp 6, Can you "select sum(price) from thisdbf where x=y" and have the result go to a var?

Not a SQL statement, but you can get that result with CALCULATE:

Calculate Sum(price) For x=y To memvar

Works on the current work area.
Previous
Reply
Map
View

Click here to load this message in the networking platform