Hi,
Did you show value of variable m.cmd?
Did you check help what is meaning "PRETEXT 7"
MartinaJ
>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