Re: SQL statement contain " character


>The problem character is a double quote, not 2 single quotes. It is used
>as an abbreviation for inches. Since the application is used by
>engineers, it occurs fairly often.
>
>I tried doubling the double quote and also embedding it between single
>quotes. Neither worked.

Use the delphi QuotedStr function.

sql := QuotedStr('update TableName set TextField = Could not save with '' in')
--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.

Relevant Pages

  • Re: handling apostrophe
    ... Try changing ur routine such that single quotes are replaced with double ... > will determine tha filter. ... >> quote is the defined and documented way to get a single quote into the ...
    (microsoft.public.sqlserver.programming)
  • Re: Kernel Panic
    ... On Thu, 2004-02-05 at 19:52, Stuart Sears wrote: ... >> They're both just single quotes. ... >> Regards Roger ... I made the assumption that the sed needed a different type of quote mark ...
    (RedHat)
  • Re: why tcl/tk doesn`t incorporate tclx, tile, etc.
    ... Why bash tries to expand backticks at this place, ... I'm using 3.00.0without your problem (backtick is taken literally). ... literal single quote between single quotes. ...
    (comp.lang.tcl)
  • Re: re-quoting (aka reconstituting a command line)
    ...     return cmdline; ... int extra_s, extra_d, quote, i; ... // embedded single quotes, use a hybrid strategy of examining ... main(int argc, char **argv) ...
    (comp.unix.shell)
  • Re: Too few parameters. Expected 1.
    ... I realize that single quotes inside double quotes are valid, ... compounding the confusion by trying to add a literal quote. ... As for the parentheses, s is defined as a string, but the string starts with ...
    (microsoft.public.access.formscoding)