save-row-changes after saved causing the record become share

Posted by mhtan88 on 11-Nov-2009 08:30

hi all,

I have a problem on after save the record after using save-row-changes, my record sometime will become share-lock, but sometime is ok.

may i know is there any command need to add in?

THank you.

Regards,

TanMH

All Replies

Posted by Håvard Danielsen on 11-Nov-2009 11:03

This is default behavior that you avoid by narrowing the record scope to the transaction block, release the record or reread it with no-lock.

Read the Handling Data and Locking Records chapter in the ABL Handbok. In particular read the Making sure you release record locks chapter.   

http://communities.progress.com/pcom/servlet/JiveServlet/download/16296-2-15429/dvhbk.pdf

Posted by mhtan88 on 11-Nov-2009 21:04

thank you Havard~

this info quite useful.

but i have to read the record before update the record. and I can't make exclusive-lock in my create query( maybe i left out something).

but any how, i managed to solved this issue like below:

h_temptable:Before-buffer:Save-Row-Changes() no-error.

h_temptable:buffer-release. 

Thank you again.

This thread is closed