You have to watch out for the delimiters. If the memo field is delimited with single quotes, which I think is the default, and you have a single quote somewhere in you memo field string, the update will fail. There is a setting for 'Quoted Identifiers' in the ODBC driver setup and in SQL Server that govern this behavoir. I choose to leave it set the way it was place and additional single quote next to all single quotes before an update. This way I can still use single quotes in my memo strings and the updates won't fail.
Charlie
Précédent
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