AutoInc pk + pessimistic lock -> Cannot edit fields!

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

Article #2849

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

#2849

From: Deimos
Date: Tue, 11 Mar 2003 09:56

8 lines
1529 bytes

Hello,
I use a table with an AutoInc primary key (Access 2000). If I turn on
the pessimistic locking I cannot edit any field of the table (via
data-aware components, such dbGrid, or simply usinf the Edit()
method). Every time I start to edit a field, an EOleException is
raised. If I don't use an AutoInc as a primary key, all seem to work
fine. I tried also to set the AutoGenerateValue for the AutoInc field,
but it seems to me that this property is ignored. Someone can help?

Technical Details

Message-ID: <olcr6vcrulbedjdpqmorvv54l9fg9sh8ol@4ax.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-09!supernews.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!proxad.net!fr.usenet-edu.net!usenet-edu.net!fu-berlin.de!news.boerde.de!nntp.cs.uni-magdeburg.de!PeerFeed.KWeb.on.ca!news.kweb.on.ca!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,292c6a5fe0c48d64,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-03-11 02:05:05 PST
From: Deimos <deimos@netplayers.it>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: AutoInc pk + pessimistic lock -> Cannot edit fields! 
Date: Tue, 11 Mar 2003 10:56:48 +0100
Message-ID: <olcr6vcrulbedjdpqmorvv54l9fg9sh8ol@4ax.com>
X-Newsreader: Forte Free Agent 1.93/32.576 English (American)
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 151.27.42.201
X-Trace: newsgroups.borland.com 1047376537 151.27.42.201 (11 Mar 2003 01:55:37 -0800)
Lines: 8
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-09!supernews.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!proxad.net!fr.usenet-edu.net!usenet-edu.net!fu-berlin.de!news.boerde.de!nntp.cs.uni-magdeburg.de!PeerFeed.KWeb.on.ca!news.kweb.on.ca!newsgroups.borland.com!not-for-mail