Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Group by
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP
Network:
Windows XP
Database:
MS SQL Server
Application:
Desktop
Divers
Thread ID:
01638251
Message ID:
01638252
Vues:
65
typing error... ,vou_no, group by
cmd="select date,vou_no,vou_type from vouchers where date>?Thisform.text3.Value and vou_type='CP' order by date,vou_no group by date,vou_no,vou_type"
	if sqlexec(con,cmd,'nav')<0
		aerror(laerror)
		messagebox(laerror[1,2])
		return
	endif
>Sir, I have these codes
>
>
>cmd="select date,vou_no,vou_type from vouchers where date>?Thisform.text3.Value and vou_type='CP' order by date,vou_no, group by date,vou_no,vou_type"
>	if sqlexec(con,cmd,'nav')<0
>		aerror(laerror)
>		messagebox(laerror[1,2])
>		return
>	endif
>
>
>
>it says:
>---------------------------
>Microsoft Visual FoxPro
>---------------------------
>Connectivity error: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'group'.
>---------------------------
>OK
>---------------------------
"Navision is evil that needs to be erazed... to the ground"

Jabber: gorila@dione.zcu.cz
Jabber? Jabbim
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform