Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Where is the sql's statement error
Message
From
18/10/2007 11:40:38
 
 
To
18/10/2007 11:38:33
Luis Navas
Independent Consultant
Auckland, New Zealand
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01261866
Message ID:
01261868
Views:
21
>Try putting codesy, instead of the *
>
Tks Luis..

but, I did already.. and same message on "GROUP BY"

>
>>Hi.. the error message says that I have an "invalid group by error".. My blind mind is not geting what should wrong down there.. Please, help me!!
>>
>>
>>SELECT  *, SUM(qty) as tot_qty, SUM(tot) as sumt;
>>		FROM cur_products;
>>	GROUP BY codesy ORDER BY sumt desc, tot_qty, desc;
>>		INTO cursor cur_prods_tot
>>
>>
>>TIA
>>
>>Claudio
"Now to him who is able to do immeasurably more than all we ask or imagine, according to his power that is at work within us, Ephesians 3:20
Previous
Reply
Map
View

Click here to load this message in the networking platform