>Hi,
>
>if you put a CHR(0) on SPT string, VFP send to ODBC a wrong string:
>
>?Sqlexec(hconnect,"SELECT 'A"+CHR(1)+"'")
>?Sqlexec(hconnect,"SELECT 'A"+CHR(0)+"'")
>
>
>If VFP build the string with a parameters fields ODBC haven't problem.
>
>The problem is on VFP SPT parser, it cut the string when found a CHR(0) char
>( VFP C routine use z-string on input).
>
>Fabio
Fabio,
Can you pass it as an expression so that it is evaluated later ?
?Sqlexec(hconnect,"SELECT 'A'+CHR(0)")
Gregory