Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Where is the sql's statement error
Message
De
18/10/2007 11:40:38
 
 
À
18/10/2007 11:38:33
Luis Navas
Independent Consultant
Auckland, Nouvelle Zélande
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01261866
Message ID:
01261868
Vues:
22
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform