>>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.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
