Re: A problem about ADOQuery->ExecSql()

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

Article #4619

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

#4619

From: Steve Love
Date: Thu, 08 Nov 2001 08:36

34 lines
1883 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!

What version of ADO are you using?
(check the version of $Program Files\common files\system\ado\msado15.dll)
The reason I ask is because I am experiencing strange lifetime behaviour
when re-using a TADOQuery component with MDAC 2.6 and above, for code 
which 
works fine in MDAC 2.52 and below.

> Jimmy Lu China
> Jimmy@chinafrida.com
Steve

Technical Details

Message-ID: <20011108.8365839@sl.engineering>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnews

References: <3be9e9d5_2@dnews>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,9370de4157e2e5b7
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-11-08 00:35:34 PST
From: Steve Love <steve.love2@virgin.net>
Date: Thu, 08 Nov 2001 08:36:58 GMT
Message-ID: <20011108.8365839@sl.engineering>
Subject: Re: A problem about ADOQuery->ExecSql()
Reply-To: Steve Love <steve.love2@virgin.net>
References: <3be9e9d5_2@dnews>
X-Priority: 3 (Normal)
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Newsgroups: borland.public.cppbuilder.database.ado
X-Newsreader: Mozilla/3.0 (compatible; StarOffice/5.2;Win32)
NNTP-Posting-Host: 213.38.79.146
X-Trace: dnews 1005208220 213.38.79.146 (8 Nov 2001 00:30:20 -0800)
Lines: 34
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnews

Reply to Parent Message