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) ENDIFODBC 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 ?