Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Group by
Message
 
To
12/07/2016 07:47:20
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP
Network:
Windows XP
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01638251
Message ID:
01638254
Views:
64
and switch ORDER BY and GROUP BY
cmd="select date,vou_no,vou_type from vouchers where date>?Thisform.text3.Value and vou_type='CP' group by date,vou_no,vou_type order by date,vou_no"
	if sqlexec(con,cmd,'nav')<0
		aerror(laerror)
		messagebox(laerror[1,2])
		return
	endif
MartinaJ

>Thanks but...
>
>Still same error
"Navision is evil that needs to be erazed... to the ground"

Jabber: gorila@dione.zcu.cz
Jabber? Jabbim
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform