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