Re: SQL statement contain " character

From: Dave Albiston <mail@xxxxxxxxxxxxxxxxxx>
Date: Sat, 28 Jan 2006 17:52:35 +0000

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

Follow-Ups:
- Re: SQL statement contain " character
  - From: Bill Hannan
- Re: SQL statement contain " character
  - From: Bill Hannan

References:
- SQL statement contain " character
  - From: Dave Albiston
- Re: SQL statement contain " character
  - From: Bill Hannan

Prev by Date: Re: SQL statement contain " character
Next by Date: Re: SQL statement contain " character
Previous by thread: Re: SQL statement contain " character
Next by thread: Re: SQL statement contain " character
Index(es):
- Date
- Thread