From: Bill Tillick on
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
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
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
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

First  |  Prev  | 
Pages: 1 2
Prev: MD5 function?
Next: Outlook 2010 Calendar Calendar