>
>This doesn't look like a Visual FoxPro BUG. Visual FoxPro does pass values from MEMO fields a little bit different, but it doesn't do string substitution as Fabio claims.
>
>
>Why write you this?
>
>I have not never written that VFP changes the replaced value,
>I have written that VFP uses two various ways to replace the parameter.
>
>When VFP replaces a VFP memo parameter ,
>it executes a substitution of the parameter with the value of the parameter within
>the original SQL string, and it sendes it the commando exactly.
>
>Explain with code:
>

>SQLEXEC(H,"SELECT ?vfp.amemoexpression")
>

>vfp send this:
>

>SQLEXEC(H,STRTRAN("SELECT ?vfp.amemoexpression","?vfp.amemoexpression","'"+vfp.amemoexpression+"'"))
>

>
>When the VFP parameter is of type "C",
>VFP changes the command to "EXEC sp_sqlexecute.." with a parameter @P1 and send this SQL parameter string; the expression value is send with the ODBC parameter binding.
>
>Fabio

Hi Fabio,

I wrote that because you description doesn't describe the way VFP works. VFP doesn't pass MEMO fields in the manner you've described here and in previous message. Please take a look into ODBC trace I've posted. You won't find "EXEC sp_sqlexecute" in it and you won't find MEMO value "inlined" into SELECT statement.

Thanks,
Aleksey.