A problem about ADOQuery->ExecSql()

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

Article #4618

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

#4618

From: Jimmy
Date: Thu, 08 Nov 2001 02:12

12 lines
1521 bytes

Hi,everyone!
        In my application,I select some records from a table by
ADOQuery1->Open(),it's ok.And then,I'll use delete some records from a
table, so I cleared the sql text by ADOQuery1->SQL->Clear(),and reassign the
sql text "delete from TABLE1 ...",and then use the ADOQuery1->ExecSQL() to
delete the records,but it doesn't work,what's the reason?
        But if I delete the records by another new query ADOQuery2,it's will
be ok.But all the properties of ADOQuery1 and ADOQuery2 are the same. why?
        Thanks!

Jimmy Lu China
Jimmy@chinafrida.com

Technical Details

Message-ID: <3be9e9d5_2@dnews>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!isdnet!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!out.nntp.be!propagator-SanJose!in.nntp.be!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,9370de4157e2e5b7,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-11-07 18:20:54 PST
Reply-To: "Jimmy" <jimmy@chinafrida.com>
From: "Jimmy" <jimmy@chinafrida.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: A problem about ADOQuery->ExecSql()
Date: Thu, 8 Nov 2001 10:12:08 +0800
Lines: 14
Organization: Chinafrida.com
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6700
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700
NNTP-Posting-Host: 61.153.23.90
Message-ID: <3be9e9d5_2@dnews>
X-Trace: dnews 1005185493 61.153.23.90 (7 Nov 2001 18:11:33 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!isdnet!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!out.nntp.be!propagator-SanJose!in.nntp.be!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews