Re: SQL statement contain " character

Dave Albiston wrote:
I am using the QuotedStr function. The SQL statement produced is valid - it is accepted if I execute it against SQL Server in Query Analyzer.

The problem is somewhere between my code and the database. Looking through the source for ADOdb.pas it appears that it is converting the statement to a parameterised statement. This is failing when the double quote is in there but works if it is taken out. It also works if I set ParamCheck to false.

I just want to know why

Dave

I don't know about ADO, but the BDE had bugs in it's parameter checking when various special characters, including the quotation mark appear. Set ParamCheck = False.

Kevin
.