>Hi:
>
>It appears the SQL Server ODBC driver doesn't like double quotes. If you use double quotes around a string on updates, long strings and empty fields cause update failure. If you use single quotes all is fine. The Quoted Identifer setting appears to have no impact.
>
>This presents a problem for MEMO fields because you can't use any single quotes in the body of the text or the update will fail because it thinks it is an extra sting delimiter. Does anyone know of a work around for this?
>
>Thanx,
>Charlie
I think, this is not correct.
Take any table with text tipe on MS SQL or ( char, does not matter)
now do the following thing
m.sql='""'+"''"+"``" .... as many as you want.
sqlexec(con,'?m.msql') , you will see , that will be able to have any number of
quates, ones, couple, not limited. If somebody will tell you to use chartrans to substitute quatas, this will work too, but why do we need this?
Don't tell this horable secret to anybody, especially at this site.
Best wishes, Vladimir Zhuravlev.
MVP-2006-2011, PHD in Math and Physics ,
host of
www.foxclub.ru,
VFP lector at Interface and Microinform companies
Head science researcher of VNIIA Rosatom.