Article View: borland.public.cppbuilder.database.ado
Article #5051Object was open
From: Hans Martin Brückmann
Date: Wed, 08 Aug 2001 13:48
Date: Wed, 08 Aug 2001 13:48
23 lines
2204 bytes
2204 bytes
Hi there, I use MDAC 2.6 + SP and BCB 5.0 E with the latest SP�s. I have 2 unbound Master/Detail tables, which are controlled by InfoPowers 2000 Comboboxes. The ADODataSets maste/detail sync. is managed by a DataSource bound to the master and the detail�s SQL expression is parameterized. Everything is fine as long as I navigate through the comboboxes. But if I try to move to another record by calling tblDetail->Locate(....) and then again start to navigate the master table by accessing the combobox, the error "Object was open" occures. Afterwards the client table is closed. I reasured that when I move through the parameterized detail -table that i move insde the master given parameter value range. Even if I try to Locate a record which is out of this range, the Problem occures. I investigated this problem now for several days and did search the newsgroups but I didn't get any satisfying solution. Neither the client nor the master table�s ExecuteOptions are set to any of these async-switches. The tables are closed at design-time and opened at runtime. I am sure that this has nothing to do with infopower - it seems that it is an ADO problem. Thanks for help in advance
Technical Details
Message-ID:
<3B714326.D1F6607F@brueckmann-gmbh.de>Path:
arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!news.maxwell.syr.edu!news1.optus.net.au!optus!intgwlon.nntp.telstra.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnewsShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII X-Google-Thread: 10698b,88b78f66967d3651,start X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2001-08-08 07:10:03 PST Message-ID: <3B714326.D1F6607F@brueckmann-gmbh.de> Date: Wed, 08 Aug 2001 15:48:22 +0200 From: Hans Martin Brückmann <HMB@brueckmann-gmbh.de> Organization: Brückmann Hard- und Software GmbH X-Mailer: Mozilla 4.7 [de]C-CCK-MCD QXW03234 (WinNT; U) X-Accept-Language: de,en MIME-Version: 1.0 Newsgroups: borland.public.cppbuilder.database.ado Subject: Object was open Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit NNTP-Posting-Host: 195.63.210.198 X-Trace: dnews 997278502 195.63.210.198 (8 Aug 2001 06:48:22 -0700) Lines: 24 Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!news.maxwell.syr.edu!news1.optus.net.au!optus!intgwlon.nntp.telstra.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews