Hi Fabio,

I wrote that because you description doesn't describe the way Visual FoxPro works. Visual FoxPro 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.


With this example and ODBC analysis you are right.

But:
- with SQL Profiler, i'm sure to have seen sp_sqlexecute,
and are sure of successful being to write the string "\"+chr(13) within to a field SQL.
- with SQL Profiler, with your code i see the memo inline !
SQL Profiler get the Server side script lines,
then it must be ODBC Client side that do the ? substitution or send a sp_sqlexecute.

I will try to found a determinist repro code for sp_sqlexecute.

Another thing:
You confirm this (fail to put "\"+chr(13)) like a MS SQL bug?

Thanks
Fabio