🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

ADO BUG !!!

#5277
From: Hans Martin Brückmann
Date: Wed, 13 Jun 2001 16:08
72 lines
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!dnews

Show 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