Renumber keys

DesmedtS

Hello,

I have a table "files" with "No" as primary key. Here are a couple of records in it, which are assigned by automatic no. series.

For Example

EX/0011 - FILE 1
EX/0013 - FILE 2
EX/0015 - FILE 3
EX/0012 - FILE 4
EX/0010 - FILE 5
....

Now, i need to renumber the "Files" table depended on a new SETCURRENTKEY. So the result must be

EX/0001 - FILE 2
EX/0002 - FILE 3
EX/0003 - FILE 1
EX/0004 - FILE 4
EX/0005 - FILE 5

To set the SETCURRENTKEY is no problem, but i have problems to assign the "No" (primary key) which must be assigned by automatic No. Series.
There will be no problem with duplicate records if i can update them one by one.

Anybody got a solution for me, because i don't find any solution for this.

Thx in advance

FPulsfort

Hope, i understand exactly, what you want 8)

Have a look at the command RENAME with which you can change the values of fields of the primary key of a record.

Regards,
Frank