Re: SQL statement contain " character

The problem character is a double quote, not 2 single quotes. It is used as an abbreviation for inches. Since the application is used by engineers, it occurs fairly often.

I tried doubling the double quote and also embedding it between single quotes. Neither worked.


Viatcheslav V. Vassiliev wrote:
Note that in Delphi you should double number of quotes - you double quote once for MS SQL Server, another time - for Delphi:

sql := 'update TableName set TextField = ''Could not save with '''' in text''';

.