[progress Communities] [progress Openedge Abl] Forum Post: Re: Trouble Deleting Data

  • Thread starter Thread starter smat-consulting
  • Start date Start date
Status
Not open for further replies.
S

smat-consulting

Guest
Sounds like your processes are attempting to read the same records, and, since one of them is in the process of deleting it, the rest of them waits for the record to be unlocked (or in this case deleted). I'd do a FOR EACH with NO-LOCK with my selection criteria, then, within the for-each reread the record with EXCLUSIVE-LOCK NO-WAIT NO-ERROR, and IF AVAILABLE THEN DELETE it. Sometimes, the for each of a second process might need to look at a record that a first process has locked, thus having to wait... Especially, if the FOR EACH criteria requires a final selection on the client-side...

Continue reading...
 
Status
Not open for further replies.
Back
Top