Re: NEWERA -- Pessimistic locking

Posted in 1997

Kenneth Gonzalez — Wed, 29 Oct 1997 13:16:34 -0800 — source: Informix-list mailing list archive (1991-1998)

Hi, Mike Ripley wrote: > However after rejecting the changes (beforeRowApplied returned > False) I cannot revisit that record make the correct changes > and accept. I get a -259 error. The only way out is to re-query. > > If I dont use the beforeRowApplied event, then record locking > and staledata work fine but I dont want to automatically accept > record changes I need to prompt the user. I ran into a similar problem before. If I remember correctly, if you do a rollback on the connection object then it should work correctly. Ken