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
---------------------------