Reiner Hutsch wrote:
>
> Lat week i posted the following question to the list. Because i didn't
> recieve a copy of my posting i will try it again ...
>
> I have the following problem:
> when i try to use a string within a SQLExecDirect Statement which
> contains a apostrophe, e.g.
>
> "update DB.TABLE set string='What's new' where keyitem=1234"
>
> i get an error message.
> Is there an escape character which i can use to indicate that the
> apostrophe in "What's" doesn't terminate the hole string?
>
> TIA
>
> Reiner Hutsch
> IMW-KÖLN

Reiner,

perhaps you could try doubling the apostrophe, like so:

"update DB.TABLE set string='What''s new' where keyitem=1234"

Hope this helps,
Bob

[log in to unmask]
[log in to unmask]