For CHR(0) issues.
With parameter the process is correct,
but i expected a free error execution with a pure SQL string command

con=SQLCONNECT()
IF con>0
	CLEAR 
	CREATE CURSOR foo (f1 M, f2 C(10) DEFAULT f1)
	INSERT INTO foo (f1) VALUES ("Test"+CHR(0)+"tesT")

	? 'Expected no errors',SQLEXEC(con,"select '"+foo.f2+"' rf2")
	? MESSAGE()
	SQLDISCONNECT(con)
ENDIF

ODBC audit:

vfp8            5e0-5a0	ENTER SQLExecDirect 
		HSTMT               02541B60
		UCHAR *             0x014AF338 [      -3] "select 'Test\ 0"
		SDWORD                    -3javascript:MessageSubmit()
[Save this message so it will appear for other members immediately] 

vfp8            5e0-5a0	EXIT  SQLExecDirect  with return code -1 (SQL_ERROR)
		HSTMT               02541B60
		UCHAR *             0x014AF338 [      -3] "select 'Test\ 0"
		SDWORD                    -3

		DIAG [37000] [Microsoft][ODBC SQL Server Driver][SQL Server]Virgoletta di chiusura mancante prima della stringa di caratteri 'Test'. (105) 

		DIAG [37000] [Microsoft][ODBC SQL Server Driver][SQL Server]Riga 1: sintassi non corretta in prossimità di 'Test'. (170) 

Can VFPT fix this in VFP9 ?

Thanks
Fabio