Hi,
If you're using row buffering then most of the question is irrelevant - all rows except the most recent will already be committed. The transaction and tableupdate only affect the last record added.
Regards,
Viv
>>I am curious about exactly when a row gets locked and when the table header gets locked under the follwing conditions:
>>
>>1 - Buffering set to 'Optimistic Row'
>>2 - Many new rows appended to table
>>3 - Begin transaction
>>4 - Tableupdate
>>5 - End transaction
>>
>>Thanks in advance for your help
>>
>>Monika
>
>I understand that without a transaction, but with buffering, the row would get locked briefly during the TableUpdate(),
>
>and that with transactions, all records changed will remain locked until the END TRANSACTION.
>
>I assume that in the case of the transaction, doing a TableUpdate() is comparable to REPLACEing without buffering: i.e., if the TableUpdate() is successful, the record will remained locked until the END TRANSACTION.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement