@six1
In the context of dbf format!!- You will change the recnum?, You *must* change the associated recnums in blob/memofields too and you *must* re-generate all indexes.... If you don't you just destroyed your dbf database.
It does not mean you lost data, but records, memo's, blob's are all disconnected and can only be restored by hand: you can not guess which picture originally belonged to which record. All data is still readable but all data is not associated with:
- indexes
- memo's
- blob fields
Unless you know the dbf formats and take care of that. I do, you don't. , 2018: as promised, and you are the first to deserve it: <not grumpy but angry
>
Better first 1. ask for explanation and 2. don't assume things without any knowledge or having read any documentation: such thing pollute and can be done in a rather better way. My aim is to educate, not spend time on bollocks.
This kind of nonsense makes it confusing for OP to read a decent answer. Which I gave.
Note the solution goes for any language, not just Lazarus/FPC.
If there is a vote on it I might be back to grumpy instead of angry.