Hi Fabio,

Of course, you don't have to explain this to me just because I was telling the same thing from the very beginning - this is not a Visual FoxPro BUG ...


In fact, on my first message, to Peter. I wrote:
This is a MS SQL bug.


You certainly found a very strange way to express your agreement.


In fact, i'm strange.

Aleksey, for every problem exists three persons sets:
1) those that cannot understand it
2) those that they think to have understood it after that someone has explained it to they
3) those that understand effectively

Those to it of the point 3)
do not have need that someone explains they the problem, enough that they think.

Thanks.
Fabio

PS Has you informed the MS SQL team for this bug?


Another Point:
It is not possible to use SQLPREPARE() like workaround.

con=SQLCONNECT()
IF con>0
	CLEAR 
	CREATE CURSOR foo (f1 M, f2 C(10) DEFAULT f1)
	INSERT INTO foo (f1) VALUES ("ABC\"+CHR(13)+"tesT")
	
	?SQLEXEC(con,"select ?foo.f1 rf1,?foo.f2 rf2")
	?rf1==foo.f1,rf2==foo.f2
	?MIN(SQLPREPARE(con,"select ?foo.f1 rf1,?foo.f2 rf2"),SQLEXEC(con))
	?rf1==foo.f1,rf2==foo.f2
	?SQLEXEC(con,"select ?foo.f2 rf2")
	?rf2==foo.f2
	?MIN(SQLPREPARE(con,"select ?foo.f2 rf2"),SQLEXEC(con))
	?rf2==foo.f2

ENDIF