>>>Please, tell me, what you mean under "renumbering records" ? This question tears me apart and I even can't sleep :)
>>>Are you really going to change RECNO() ? Or you are speaking about a simple REPLACE...ALL ?
>>
>>Well, I needed to change the sequence number (it's an integer field in my table). So, for each FK I needed a sequence from 1 to the number of records for this FK. I also needed to figure out how would I change the number to not mess up the original numbering (at the end, I didn't take this into consideration, so I may have some surprises tomorrow).
>>
>>Anyway, while you were sleeping I already implemented quite simple algorithm and ran it in production.
>>
>>So, you may go to sleep or are you starting your work day already? If yes, all the best to you and good luck!
>
>What I have done in similar cases is to get all the records into a cursor, and then process the cursor with a SCAN. For each record in the cursor, go to the record in the original table.
>
>This way, you avoid the potential problem that renumbering affects the SCAN loop.
Yes, that's exactly how did I do it. I selected all duplicates in the cursor and then processed it. However, I probably didn't preserve the original sequence number and the number (especially 1 - primary) was important.
If it's not broken, fix it until it is.
My Blog