Re: NEWERA -- Pessimistic locking

Posted in 1997

Mike Ripley — Thu, 30 Oct 1997 09:46:17 +0000 — source: Informix-list mailing list archive (1991-1998)

In article <3457A7B2.22FB@informix.com>, Kenneth Gonzalez <kengon@informix.com> writes >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 Thanks Ken but! Still get same error after I have put in the rollback. Even tried to do a row revert in the beforeRowApplied and return true so as not to upset the applyRowSQL function but still goes wrong on the next valid accept. Any other ideas please. -- Mike Ripley