>Naomi,
>
>That's it, This is in 7. I see I forgot and specified 9 in the header.
>
>IAC I don't just need to turn off the prompt. I've got some bad logic somewhere. As you suggest, I will concentrate on the SELECT lines.
>
>The code SELECTS deleted records from any table that has them, then switches to a same-named dbc and table in an \archive folder below \data then does a scatter/gather to get them into the archive. Then the pk is replaced with recno(). It was only a matter of time until a renumbered pk was deleted and collided with the same pk in the archive. My problem is the ON ERROR SomeOtherError = .T. logic just hides the problem.
>
>Thanks for your help.
>
>Al Allison
>
>PS: As I asked you before, what happened to your picture?
Can you disable error handler for now?
As for the picture, I don't have a good recent one and even though I have my ~5+ years old picture on some other sites, I decided against it here.
If it's not broken, fix it until it is.
My Blog