Re: SQL statement contain " character

The statement causing problems contains other fields - including a time field which, of course, includes a colon.

I think the ADO component can be confused into thinking there is a parameter when there is none. Some statements worked fine. In other cases, I re-arranged the statement and it worked.

Setting ParamCheck to false avoids the issue.

Dave

Brian Bushay TeamB wrote: 
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

.