Article View: borland.public.cppbuilder.database.ado
Article #3445Re: Character ' causing a syntax error...
From: MarkR
Date: Sat, 24 Aug 2002 23:55
Date: Sat, 24 Aug 2002 23:55
16 lines
1502 bytes
1502 bytes
You will probably have to use a parameter then
"Robert A. Vasquez" <rvasquez2001@yahoo.com> wrote in message
news:3d65c4ca$1@newsgroups.borland.com...
> I have a TMemo that whose contents I need to place in my table. I do this
by
> using:
>
> MyQuery->SQL->Add(" SET S.MyMemoField = '"+MyMemo->Lines->Text+"',");
>
> The problem is that if the Memo field contains the word "let's" it throw's
> off a syntax error.
>
> What would be the best way to allow such an entry to post correctly?
>
>
Technical Details
Message-ID:
<3d681cd4$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-06!sn-xit-04!supernews.com!newsfeed.gamma.ru!Gamma.RU!nntp.abs.net!news.maxwell.syr.edu!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!newsgroups.borland.com!not-for-mailReferences:
<3d65c4ca$1@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,c9672ab417972539 X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2002-08-24 17:07:39 PST From: "MarkR" <mark.richards8@wapthespamntlworld.com> Newsgroups: borland.public.cppbuilder.database.ado References: <3d65c4ca$1@newsgroups.borland.com> Subject: Re: Character ' causing a syntax error... Date: Sun, 25 Aug 2002 00:55:15 +0100 Lines: 18 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 NNTP-Posting-Host: 213.107.142.213 Message-ID: <3d681cd4$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1030233300 213.107.142.213 (24 Aug 2002 16:55:00 -0700) Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-06!sn-xit-04!supernews.com!newsfeed.gamma.ru!Gamma.RU!nntp.abs.net!news.maxwell.syr.edu!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!newsgroups.borland.com!not-for-mail