Re: A problem about ADOQuery->ExecSql()

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

Article #4701

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

#4701

From: Stephane Baillargeon
Date: Thu, 15 Nov 2001 22:34

18 lines
1613 bytes

Try closing and reopenning the query
"Jimmy" <jimmy@chinafrida.com> wrote in message news:3be9e9d5_2@dnews...
> 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: <3bf443a5$1_1@dnews>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!news.maxwell.syr.edu!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!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-15 14:39:22 PST
From: "Stephane Baillargeon" <mbaillargeon@sympatico.ca>
Newsgroups: borland.public.cppbuilder.database.ado
References: <3be9e9d5_2@dnews>
Subject: Re: A problem about ADOQuery->ExecSql()
Date: Thu, 15 Nov 2001 17:34:14 -0500
Lines: 20
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: 65.94.174.215
Message-ID: <3bf443a5$1_1@dnews>
X-Trace: dnews 1005863845 65.94.174.215 (15 Nov 2001 14:37:25 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!news.maxwell.syr.edu!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!dnews

Reply to Parent Message