J
James Palmer
Guest
Reposting with formatting so I can read it. Hi I am currently implementing V11.2 from V102B and experienced the following different behavior. I have the following for each loop with a database trigger on the child table: for each parent no-lock, each child no-lock where child.id = parent.id: 'do something' end. A database trigger on the find event: TRIGGER PROCEDURE FOR FIND OF child. if child.type = "deleted" then return error. The trigger code should skip child records that have a type of 'deleted'. This loop works fine in V102B but in V11.2 it does not finish properly. It works for a while then it drops out of the procedure and does not reach the end of the for each loop to continue. If I use 2 for each loops, one for the parent and one for the child, that works correctly. Has anybody experienced the same behavior and has maybe a workaround. Thanks for any help. - See more at: https://community.progress.com/community_groups/openedge_development/f/19/t/14989.aspx?Redirected=true#sthash.GUGhUMUz.dpuf
Continue reading...
Continue reading...