HowTo: Lock one/set of records

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

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by yupod Thu, 08 Feb 2001 16:48

#5765

Author: yupod
Date: Thu, 08 Feb 2001 16:48

13 lines
1479 bytes

Hello!
I use BCB5 with ADOExpress, connecting to Access97 mdb,
I need to lock one record in a table (or result of query) so that nobody
else can edit it. Once this record is updated by user I need to unlock it.
The only way I can do it now is to set Connection's property Mode to
Exclusive. But this
makes all records in table locked and is unacceptable to me...
I thought if I set ADODataset's properties CursorType=ctKeySet and
LockType=ltPessimistic this will do it, but it did not affect anything

Please, help me with advice or sample code,
Thank you in advance,
Yuriy.

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads