Re: A problem about ADOQuery->ExecSql()

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

Article #4626

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

#4626

From: SteveL
Date: Fri, 09 Nov 2001 11:15

26 lines
1693 bytes

On Fri, 9 Nov 2001 08:53:06 +0800, "Jimmy" <jimmy@chinafrida.com> wrote:

>Hi,Steve!
>        The version of ADO I'm using is "2.60.6526.0", maybe this is the
>reason you said.But the strange thing is I still can do "select..."
>operation by ADOQuery1->Open() after a Open operation has been done,but only
>ExecSql() will not be work!How to resolve it?
>
>Jimmy Lu China
>Jimmy@chinafrida.com
>

The answer appears to be not to reuse the TADOQuery object for both SELECT
and UPDATE queries (for now, anyway).

See the "MDAC2.6 crashing..." thread in this forum.

Steve
--
mailto:steve.love@essennell.co.uk
SMILE! And people will wonder
what you're up to!

     - ACCU -  accu.org -
Professionalism in Programming

Technical Details

Message-ID: <ijenutgcv0t42ktjpd6j78hs12r69eddru@4ax.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!newshub2.rdc1.sfba.home.com!news.home.com!newsfeed.mesh.ad.jp!uunet!osa.uu.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews

References: <3be9e9d5_2@dnews> <20011108.8365839@sl.engineering> <3beb28c1$1_1@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-09 03:16:52 PST
From: SteveL <junk@essennell.co.uk>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Re: A problem about ADOQuery->ExecSql()
Date: Fri, 09 Nov 2001 11:15:31 +0000
Message-ID: <ijenutgcv0t42ktjpd6j78hs12r69eddru@4ax.com>
References: <3be9e9d5_2@dnews> <20011108.8365839@sl.engineering> <3beb28c1$1_1@dnews>
X-Newsreader: Forte Agent 1.8/32.548
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 62.252.68.26
X-Trace: dnews 1005304189 62.252.68.26 (9 Nov 2001 03:09:49 -0800)
Lines: 26
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!newshub2.rdc1.sfba.home.com!news.home.com!newsfeed.mesh.ad.jp!uunet!osa.uu.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews

Reply to Parent Message