Re: ADOQuery can't use SQL delete statement

Article View: borland.public.cppbuilder.database.ado

Article #3431

Back to borland.public.cppbuilder.database.ado Previous Next

#3431

From: Jackie
Date: Wed, 21 Aug 2002 00:28

27 lines
1565 bytes

Yeah Working !

Thank x 10000


"Jackie" <tkfi@hotmail.com> ���g��l��
news:3d621d13@newsgroups.borland.com...
> Hi All
>
> I used an Access database , Where I try to delete record by using SQL
Delete
> statement , which look like :
>
>     ADOQuery1->Active=true;
>     ADOQuery1->SQL->Clear();
>     ADOQuery1->SQL->Add("delete from table where id = '102' ");
>     ADOQuery1->ExecSQL();
>     ADOQuery1->Open();
>
> I got throw exception , but I can do that delete statement on the SQL
> Explorer.
> Is that the ADOQuery can't use SQL delete statement .
>
> Please Help
> Thanks a lot
>
>

Technical Details

Message-ID: <3d62df04@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!sn-xit-04!supernews.com!iad-peer.news.verio.net!news.verio.net!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!newsgroups.borland.com!not-for-mail

References: <3d621d13@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII
X-Google-Thread: 10698b,9d1e64bf1f21a949
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-08-20 17:41:24 PST
From: "Jackie" <tkfi@hotmail.com>
Newsgroups: borland.public.cppbuilder.database.ado
References: <3d621d13@newsgroups.borland.com>
Subject: Re: ADOQuery can't use SQL delete statement 
Date: Wed, 21 Aug 2002 08:28:00 +0800
Lines: 29
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4807.1700
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
NNTP-Posting-Host: 202.175.77.154
Message-ID: <3d62df04@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1029889796 202.175.77.154 (20 Aug 2002 17:29:56 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!sn-xit-04!supernews.com!iad-peer.news.verio.net!news.verio.net!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!newsgroups.borland.com!not-for-mail

Reply to Parent Message