Diman
Admin
Admin
| Posts: 1509 |  |
Karma: 20
|
|
Re:multi user?
|
|
Posted: 2007/05/14 01:48 |
|
|
|
|
when using AnyDac for multi-user, is there anything I should be aware of?
In general, it is DBMS responsibility to maintain concurrent users access to a data. But application can take care to reduce number of access conflicts. With AnyDAC, you can specify how AnyDAC should lock the record before user will edit it and post the changes. For details see AnyDAC_Architecture.doc, chapter 6.2.3 "Concurrency Control".
- when AnyDac goes to edit, does it fully lock the whole table or just the row?
No, not a table. Only in pessimistic locking mode with immediate locking, AnyDAC will lock current record before starting to edit it.
- do I have to trap any events so two users don't edit the same record?
That is question to the application business logic, than to AnyDAC.
- is there any special processing required, such as making separate ADConnections?
No.
- do you have small example how to use AnyDac in multi-user mode?
No examples. Just build application, adjust locking mode according your application requirements and ... use it 
Regards,
Dmitry
|
|
