RE: Triggered Embedded SQL Update Releasing Native Record Lock in Caller

I had the same error message when I tried to RPG update after an %eof condition.Your situation is different but I'm mentioning another example that produces "Operation sequence for member xxxxx not valid" in case this helps.Yours truly,Glenn Gundermannglenn.gundermann@xxxxxxxxx(416) 317-3144---
-------- Original message --------From: Stephen Coyle <stephenfcoyle@xxxxxxxxx> Date: 2022-09-30 12:05 p.m. (GMT-05:00) To: rpg400-l@xxxxxxxxxxxxxxxxxx Subject: Triggered Embedded SQL Update Releasing Native Record Lock in Caller Hi Everyone,I am getting the message "Operation sequence for member xxxxx not valid".That in itself is a little strange as I would have expected somethingalong the lines of "Update without a prior read".No matter....the sequence of events that leads up to this...RPG Program A has File X and File Z defined as Update FullProgram A reads File XProgram A Chains and Updates File ZTrigger Program on File Z runs SQL Update on the same File X recordread prior by Program AProgram A attempts Update of File X record.....BOOM!Looks like the SQL update being done in the trigger has released therecord that Program A had locked.I've seen in the archive the same situation but the solution to movesome code around will be a problem due to some of my code beingexecuted in a trigger.I was hoping someone might know of a way for the SQL update in thetrigger to not interfere with a native RPG record lock in the caller?Any help appreciated....thank you,- Steve-- This is the RPG programming on IBM i (RPG400-L) mailing listTo post a message email: RPG400-L@lists.midrange.comTo subscribe, unsubscribe, or change list options,visit: https://lists.midrange.com/mailman/listinfo/rpg400-lor email: RPG400-L-request@lists.midrange.comBefore posting, please take a moment to review the archivesat https://archive.midrange.com/rpg400-l.Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.Help support midrange.com by shopping at amazon.com with our affiliate link: https://amazon.midrange.com