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
You can insert new records, transfer the fields and assign the “no” without validate ( := ). The command INCSTR (String) can help you to imitate the assign by autom. No. Serie. This might help you.
Yes you are right. I also thought about it. But the problem is, the “no.” that is assigned by a No. serie is determined by a value in a the table. Greetzzzz Steve
Can you explain to me, why this is a problem? Perhaps I need more Information to understand this problem…