| Subject | Updating one field on a transaction locks whole row? |
|---|---|
| Author | Hugo |
| Post date | 2001-06-20T18:43:21Z |
I'm executing a "long duration" Stored Procedure which includes an
UPDATE TABLE SET FIELD1=value .
I must wait until StoredProcedure finish, to automatically commit transaction to server, and meanwhile I can't post any other changes to table TABLE, even in other fields than FIELD1.
Is this the current behavior? Or is there a way to lock ONLY that field I need to update inside the Stored Procedure?
Thanks a lot in advance,
Hugo.
[Non-text portions of this message have been removed]
UPDATE TABLE SET FIELD1=value .
I must wait until StoredProcedure finish, to automatically commit transaction to server, and meanwhile I can't post any other changes to table TABLE, even in other fields than FIELD1.
Is this the current behavior? Or is there a way to lock ONLY that field I need to update inside the Stored Procedure?
Thanks a lot in advance,
Hugo.
[Non-text portions of this message have been removed]