SQL statement contain " character

My application stores text which often contains the " character for inches. I am dynamically constructing a statement like:

update Tablename
set TextField = 'Could not save with " in text',
..
..
where TableID = ..

The statement is accepted by SQL Server 2000 using Query Analyzer but fails when I execute it with a TADOQuery in D2005. The error message is:

'Parameter object is improperly defined. Inconsistent or incomplete information was provided.'

If I remove the " character it works. It also works with the character if I set ParamCheck to false.

Is there an explanation or is this a bug?

Dave
.

Relevant Pages

  • Dark Horse for October 2005
    ... art by Timothy Green II. ... But hers is not the only secret revealed?the ... 48 pages, black and white, $3.99, in stores on Oct. 12. ... CLASSIC COMIC BOOK CHARACTER: MAGNUS, ...
    (rec.arts.comics.misc)
  • Re: Competition 58 ready to download
    ... Did you intentionally roll a character that has no ?ID in the stores? ... with unknown flavors to sell to the stores. ...
    (rec.games.roguelike.angband)
  • Re: [Lit.] Buffer overruns
    ... >> If there was a newline read it stores it. ... >> and stores them into the buffer pointed to by s. ... A '\0' is stored after the last character in the buffer. ...
    (sci.crypt)
  • Re: checking for a particular string in a cell
    ... I want to search for the character "ABC Stores" ... in a cell and it may be caps or small it shud return a value. ... This will return the position of the first character in the string where 'Stores' appears, ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Output of a program
    ... (You'll need to deal with the '\n' character that fgets() ... the string, and with its behavior if the input line is longer than ...
    (comp.lang.c)