En delphi usando F1 sobre las propiedades de un objeto podés solucionar mucho: En este caso sobre "LOCK TYPE" del ADO Table
ltUnspecified
A specific lock type has not been specified or determined.
ltReadOnly
Read-only; the current execution cannot modify data.
ltPessimistic
Pessimistic locks; locks instantiated on a record-by-record basis when edit mode is applied to a record.
ltOptimistic
Optimistic locks; locked are initiated on a record-by-record basis, but only when updates are applied and a record is being updated.
ltBatchOptimistic Optimistic batch updates; used for batch update mode rather than immediate update mode.
Me parece que mejor es implementar un procedimiento almacenado con lock type
Saludos
__________________
And I'd like an hour on the holodeck with Seven of Nine.
|