 |
rob
Novice
Joined: 12 Oct 2000
Posts: 30
Location: Australia
|
 Posted: Mon Nov 25, 2002 2:41 am
Database Number System
|
I had about 800 items in my database and had to delete about the last 100 for a certain reason and I noticed the next number of the next record to be added doesnot change back. I.e it was at 801 and after deleting 100 records I could find no way to set it back to my last entry i.e 701. I want all my item numbers to be in sequence so I can keep track of how many items i have. Now i have about 1500 items in their all in sequence but when i add the next one it will be added to 1600. Is there any way to change this?
Cheers
Rob |
|
|
|
|
LightBulb
MASTER
Joined: 28 Nov 2000
Posts: 4817
Location: USA
|
Posted: Mon Nov 25, 2002 5:01 am
|
There's a fairly obvious answer.
Create a new database and transfer the data to it.
LightBulb
Senior Member |
|
|
|
|
rob
Novice
Joined: 12 Oct 2000
Posts: 30
Location: Australia
|
Posted: Mon Nov 25, 2002 5:44 am
|
I would do that but all the information in the database was entered directly while playing my mud. Do you know of an easy way to do this transfer? Can I do it somehow by extracting all the data and reentering it all at once?
|
|
|
|
|
LightBulb
MASTER
Joined: 28 Nov 2000
Posts: 4817
Location: USA
|
Posted: Mon Nov 25, 2002 3:57 pm
|
Export.
Import.
Of course, you'll have to do this again every time you delete any records. There's really no need to have continuous record numbers since the number of records is readily available with the %numrec function.
LightBulb
Senior Member |
|
|
|
|
|
|
|
