Article View: borland.public.cppbuilder.database.ado
Article #5277ADO BUG !!!
From: Hans Martin Brückmann
Date: Wed, 13 Jun 2001 16:08
Date: Wed, 13 Jun 2001 16:08
72 lines
3218 bytes
3218 bytes
Dies ist eine mehrteilige Nachricht im MIME-Format.
--------------4BDD9FF78195687DA8E48110
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Hi there
I have installed BCB 5.0 Enterprise and Upgrade#1
I have installed ADO Upgrade#1
A BUG ?:
I just made a simple AdoQuery connection to a MS-SQL 7.0 Server. The
table is a primary key indexed autoinc one. Isolation Level is
cursor-stability. CursorLocation is clUseServer.
I also loaded all fields persistent and marked the PK-field as
arAutoInc. The data is shown in a grid and I use the normal
navigatorbuttons.
A:Now I do the following steps:
1. Add a new record by skiping over the last one. Save my changes.
Autoincrement-value is ok.
2. Delete this record immediately.
Result: So my grid gets empy! I can�t move back to any record, even if I
cancel my edit. The only way
I found is to move back via bookmark.
B: Next Test:
Delete one record and then move to the first and then to the last by
using buttons of the NavigatorButtons.
An exception occurs:
"Either Eof or Bof is True or the current record is deleted..."
This bug should have been eliminated by the Upgrade but it is still
there.
C: Insert a record and then make refresh by pushing the button on the
Navigator or call ADODataSet1->Refresh()
An exception occurs:
"Some Errors occured...", German: "Es sind einige Fehler
aufgetreten" (EOleException)
I looks like that the AdoDataSet is corrupt if the ammount of records
has changed.
What is wrong, are there any swichtes wrong ? Or is it a bug!
If there is no fine workaround what are the alternatives?
thanks in advance
HMB
--------------4BDD9FF78195687DA8E48110
Content-Type: text/x-vcard; charset=us-ascii;
name="HMB.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Visitenkarte f�r Hans Martin Br�ckmann
Content-Disposition: attachment;
filename="HMB.vcf"
begin:vcard
n:Br�ckmann;Hans Martin
tel;work:+49 6441 9658-32
x-mozilla-html:FALSE
url:http://www.brueckmann-gmbh.de
org:Br�ckmann Hard- und Software GmbH
adr:;;;;;;
version:2.1
email;internet:hmb@brueckmann-gmbh.de
fn:Hans Martin Br�ckmann
end:vcard
--------------4BDD9FF78195687DA8E48110--
Technical Details
Message-ID:
<3B278FE9.CF22BEB3@brueckmann-gmbh.de>Path:
arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!nntp-relay.ihug.net!ihug.co.nz!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!dnewsShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII X-Google-Thread: 10698b,603d5e0ba87e9b0b,start X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2001-06-13 09:11:11 PST Message-ID: <3B278FE9.CF22BEB3@brueckmann-gmbh.de> Date: Wed, 13 Jun 2001 18:08:09 +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: ADO BUG !!! Content-Type: multipart/mixed; boundary="------------4BDD9FF78195687DA8E48110" NNTP-Posting-Host: 195.88.186.221 X-Trace: dnews 992448362 195.88.186.221 (13 Jun 2001 09:06:02 -0700) Lines: 73 Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!nntp-relay.ihug.net!ihug.co.nz!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!dnews