Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement