ADOQuery can't use SQL delete statement

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

Article #3428

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

#3428

From: Jackie
Date: Tue, 20 Aug 2002 10:40

17 lines
1340 bytes

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: <3d621d13@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!news.maxwell.syr.edu!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,9d1e64bf1f21a949,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-08-20 03:51:18 PST
From: "Jackie" <tkfi@hotmail.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: ADOQuery can't use SQL delete statement 
Date: Tue, 20 Aug 2002 18:40:30 +0800
Lines: 19
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.112
Message-ID: <3d621d13@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1029840147 202.175.77.112 (20 Aug 2002 03:42:27 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!sn-xit-04!supernews.com!news.maxwell.syr.edu!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!newsgroups.borland.com!not-for-mail