Prev: MD5 function?
Next: Outlook 2010 Calendar Calendar
From: Bill Tillick on 15 Jul 2010 01:09 Success! I still don't know why Joachim's code doesn't work but I have found that by extracting Recnos into an array and then processing the array in reverse (i.e. deleting highest Recno first) that my program now works perfectly for deleting Multiple Selections without skipping records/rows. Thanks, Bill
From: Geoff Schaller on 15 Jul 2010 04:28 This is because you missed the point that DBServer skips on the delete. Processing in reverse then helps ignore this. "Bill Tillick" <wtillick(a)gmail.com> wrote in message news:ec1bca1e-8231-4f7d-a6e5-5e87f4f62c20(a)s17g2000prh.googlegroups.com: > Success! > I still don't know why Joachim's code doesn't work but I have found > that by extracting Recnos into an array and then processing the array > in reverse (i.e. deleting highest Recno first) that my program now > works perfectly for deleting Multiple Selections without skipping > records/rows. > > Thanks, > Bill
From: Bill Tillick on 15 Jul 2010 05:27 Geoff, No, I didn't miss the point. It was because it was pointed out by Steve that DBServer skips on the delete that I decided to process in reverse. I don't see how else I could have processed the selection unless I skipped -1 after each delete? Regards, Bill
From: Geoff Schaller on 15 Jul 2010 18:34
But you didn't <g> And even if you did, where it skips back to is not guaranteed. "Bill Tillick" <wtillick(a)gmail.com> wrote in message news:8ba5868e-fc8b-47da-8d5a-8d34be066996(a)x1g2000prc.googlegroups.com: > Geoff, > No, I didn't miss the point. It was because it was pointed out by > Steve that DBServer skips on the delete that I decided to process in > reverse. I don't see how else I could have processed the selection > unless I skipped -1 after each delete? > > Regards, > Bill |