HP3000-L Archives

February 1997, Week 2

HP3000-L@RAVEN.UTC.EDU
Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
Strings in ODBC Calls
From:
Reiner Hutsch <[log in to unmask]>
Reply To:
Reiner Hutsch <[log in to unmask]>
Date:
Wed, 12 Feb 1997 19:51:41 +0100
Content-Type:
text/plain
Parts/Attachments:
text/plain (15 lines) 
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

ATOM RSS1 RSS2