Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL quest
Message
From
01/08/2001 05:28:46
 
 
To
31/07/2001 16:47:32
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00538004
Message ID:
00538203
Views:
8
This message has been marked as the solution 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?
>
>Try
>
>SELECT SUM(price) FROM thisdbf WHERE x=y INTO ARRAY laResult
>
>? laResult[1]

? laResult

Just as if it a var. In VFP reference to array name returns the first element value ;)
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.com
ICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs

It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.
Previous
Reply
Map
View

Click here to load this message in the networking platform