Synchronising ADOConnections

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

Article #3942

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

#3942

From: Thomas Wagener
Date: Fri, 24 May 2002 07:50

18 lines
1749 bytes

Hi,

I have a problem concerning the sychronisation of ADOConnections in
different threads. When I call a delete statement (via a TADOCommand) on a
table, a query in a different thread is still giving back the deleted record
set. The application works on a user database. When I delete a user in one
thread the username is still displayed in the other, although I obtain the
user list definitely after the first command was executed.
Each thread holds a TADOConnection that is only closed but not destroyed
between the queries on the database. I suspect that the caches of the
connections are not updated properly. Is there a magic parameter for
TADOConnection that might remedy this problem, do I have to destroy the
connection after each query, or am I completely on the wrong track? I am
using CBuilder 5.

Any suggestions,

Thomas

Technical Details

Message-ID: <3cedf0d8$1_1@dnews>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!peer.news.opaltelecom.net!newsfeed.icl.net!newsfeed1.cidera.com!Cidera!news.maxwell.syr.edu!news.stealth.net!news.stealth.net!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnews

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,588b209f7c6a4a7e,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-05-24 01:00:31 PST
From: "Thomas Wagener" <Thomas.Wagener@web.de>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Synchronising ADOConnections
Date: Fri, 24 May 2002 09:50:47 +0200
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: 217.0.58.86
Message-ID: <3cedf0d8$1_1@dnews>
X-Trace: dnews 1022226648 217.0.58.86 (24 May 2002 00:50:48 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!peer.news.opaltelecom.net!newsfeed.icl.net!newsfeed1.cidera.com!Cidera!news.maxwell.syr.edu!news.stealth.net!news.stealth.net!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnews