>Good Morning
>
>Sir following codes work fine in sqlserver as you can see in attached image
>but when I use in VFP as
>
>

>text TO m.cmd NOSHOW TEXTMERGE PRETEXT 7
>	select date,acc_code,sum(qty)as qty,rate,sum(qty*weight)as weight
>	sum(rate*qty)as cr_amount from sectsalp
>	where vou_type='SR' and type='P'
>	group by date,acc_code,rate
>	order by date,acc_code,rate
>ENDTEXT
>
>if sqlexec(con,cmd,'tableb')<0
>	aerror(laerror)
>	messagebox(laerror[1,2])
>	lok=.f.
>	return.f.
>endif
>

>
>It shows this error message
>
>Connectivity error: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 'sum'.
>
>Why the same code work fine in SQLSERVER but not in vfp?
>
>Please help

Because it's not the same code. You missed a comma at the end of the first line.