Re: SQL statement contain " character
- From: Brian Bushay TeamB <BBushay@xxxxxxxxx>
- Date: Mon, 30 Jan 2006 22:05:17 -0600
>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
I just tested this dynamically assembled SQL against the Orders table in the
Northwind sample database. Tell me what is different with what you are doing?
CommandText := 'Update orders set shipaddress = '+
QuotedStr('This is a test " string with doublequote')+' where OrderID = 10248';
--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.
- Follow-Ups:
- Re: SQL statement contain " character
- From: Dave Albiston
- Re: SQL statement contain " character
- References:
- SQL statement contain " character
- From: Dave Albiston
- Re: SQL statement contain " character
- From: Viatcheslav V. Vassiliev
- Re: SQL statement contain " character
- From: Dave Albiston
- Re: SQL statement contain " character
- From: Brian Bushay TeamB
- Re: SQL statement contain " character
- From: Dave Albiston
- SQL statement contain " character
- Prev by Date: Re: Could not find installable ISAM
- Next by Date: Re: Please help with a serious issue
- Previous by thread: Re: SQL statement contain " character
- Next by thread: Re: SQL statement contain " character
- Index(es):
Relevant Pages
|
