>>Gregory provided you with the correct way of using parameters. One possible gotcha - check out the types of the parameters, quite often VFP sends them wrongly (say, float for numeric, etc.) In those cases you can use CAST to correct type inside the ?mproperty, e.g.
>>
>>'cast(?mProperty as NUMERIC(17,0))'
>
>wouldn't it be better to send
>
>?cast(mProperty as n(17,0))
>
>as a parameter?
No, the conversion in VFP, I think, will do nothing. The CAST needs to be in the SQL string sent to the server.
If it's not broken, fix it until it is.
My Blog