Information générale
Titre:
SQL Server ODBC Driver doesn't like double quotes
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement