Re: SQL statement contain " character

As Vassiliev stated " (double quotes) below you need two ' (single quotes)
to force them into a string var. It can make SQL statemenst you build
dynamicly hard to read and debug.

Bill

"Dave Albiston" <mail@xxxxxxxxxxxxxxxxxx> wrote in message
news:43dbae02$1@xxxxxxxxxxxxxxxxxxxxxxxxx
>I am constructing the SQL dynamically so I can't set parameter type.
>Looking at the source, it looks like the ADO component creates a
>parameterised statement on the fly. I suspect a bug in there because in
>some other statements the " character is acceptable.
>
> Dave
>
> Bill Hannan wrote:
>> It works for me delphi 7 and Sql 2000
>>
>> Parameter datatype ftString.
>>
>> I'd check your parameter data type.
>>
>> Bill
>


.