AutoInc pk + pessimistic lock -> Cannot edit fields!

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

Article #2914

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

#2914

From: Deimos
Date: Tue, 04 Mar 2003 16:24

8 lines
1305 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: <b4d9364d.0303040824.5433dd0e@posting.google.com>

Path: arc1-ca.pugleaf.net!archiver1.google.com!postnews1.google.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,43d890f9277a9158,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-03-04 08:24:27 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!postnews1.google.com!not-for-mail
From: deimos@netplayers.it (Deimos)
Newsgroups: borland.public.cppbuilder.database.ado
Subject: AutoInc pk + pessimistic lock -> Cannot edit fields!
Date: 4 Mar 2003 08:24:27 -0800
Organization: http://groups.google.com/
Lines: 8
Message-ID: <b4d9364d.0303040824.5433dd0e@posting.google.com>
NNTP-Posting-Host: 151.27.40.181
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1046795067 14515 127.0.0.1 (4 Mar 2003 16:24:27 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 4 Mar 2003 16:24:27 GMT