Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Elegant SQL
Message
From
11/05/2005 15:37:25
 
 
To
11/05/2005 12:04:30
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01012923
Message ID:
01013124
Views:
15
Thanks, but look at Fabio's solution.

>
>
>
>SELECT SUM(eggs) as sqTotalEggs, SUM(hi_eggprice * eggs) as sqTotalAmt ;
>FROM ( ;
>     SELECT hi_chicks / hi_htchpct as eggs, ;
>      hi_eggprice ;
>     FROM it!hatcinfo ;
>      WHERE hi_invnum = 'A0017' ;
>        AND !DELETED() ;
>    ) as A ;
> into CURSOR curs2
>
>
>
>Not Tested
Previous
Reply
Map
View

Click here to load this message in the networking platform