Article View: borland.public.cppbuilder.database.ado
Article #5365ADO, DELETE and a GRID
From: Hans Martin Brückmann
Date: Tue, 12 Jun 2001 08:18
Date: Tue, 12 Jun 2001 08:18
50 lines
2526 bytes
2526 bytes
Dies ist eine mehrteilige Nachricht im MIME-Format.
--------------5FD356F040335E9D1BC131A2
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Hello to all
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.
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.
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.
What is wrong, are there any swichtes wrong ?
thanks in advance
HMB
--------------5FD356F040335E9D1BC131A2
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
--------------5FD356F040335E9D1BC131A2--
Technical Details
Message-ID:
<3B25D063.759D2FBC@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!t-online.de!news-lei1.dfn.de!news-fra1.dfn.de!news-koe1.dfn.de!RRZ.Uni-Koeln.DE!nntp.CS.Uni-Magdeburg.De!PeerFeed.KWeb.on.ca!dnewsShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII X-Google-Thread: 10698b,8f335934e73d39d5,start X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2001-06-12 01:22:09 PST Message-ID: <3B25D063.759D2FBC@brueckmann-gmbh.de> Date: Tue, 12 Jun 2001 10:18:43 +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, DELETE and a GRID Content-Type: multipart/mixed; boundary="------------5FD356F040335E9D1BC131A2" NNTP-Posting-Host: 195.88.186.221 X-Trace: dnews 992333800 195.88.186.221 (12 Jun 2001 01:16:40 -0700) Lines: 51 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!t-online.de!news-lei1.dfn.de!news-fra1.dfn.de!news-koe1.dfn.de!RRZ.Uni-Koeln.DE!nntp.CS.Uni-Magdeburg.De!PeerFeed.KWeb.on.ca!dnews