Hi Soonhual, CommitRetaining keeps the transaction context, but saves all DB-alterations to disk. So the transaction is still open. If now you change again a value, you'll get a dead-lock-error, because you try to commit something, which is still used in an open transaction.
Use commit and re-open the table. You can use GetBookmark or remember the key of your active record to re-position the table accordingly. Use TIBQuery and a TIBUpdateSQL , it is more flexible than a TIBTable allone. Have fun Bob > > > I have > > a > TIBDatabase > TIBTransaction > TIBTable or TIBDatabase which is linked each other > > then i double click on the IBTransAction and set it to > READCOMMITED > > for the save button onclick event, i put the following code: > > IBDatabase.Post; > IBTransAction.CommitRetaining; > > When i click the save button, It seems like have problem with the error > message with: nowait ... deadlock or something like that ... i'm in > office now and not sure what's the exactly message, but does anyone has > any idea what's the prob? thanks in advance > > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > > [Non-text portions of this message have been removed] > > > > ----------------------------------------------------- > Home page: http://groups.yahoo.com/group/delphi-en/ > To unsubscribe: [EMAIL PROTECTED] > Yahoo! Groups Links > > > > > > > ----------------------------------------------------- Home page: http://groups.yahoo.com/group/delphi-en/ To unsubscribe: [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/delphi-en/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
