Auto number in a replica database ?

baye · Feb 8, 2002

I have just replicated a database and hence the field I used as the record identifier (customer No. in this case)was changed to 'random'and 'Long integer' field values.
I would like this number to be a four or five digit number and of a positive value is there anyway I can do this. As the number now is to long and uses negative values.
Any help would be very much apprehicated.
thanks

thegman · Feb 13, 2002

if you are using something along the lines of MySQL or another SQL-style database, you could make an auto_increment field for your Customer no. This would make the numbers start at 0 and go up by themselves as customers were added. To make the number always be 4-5 digits, it really depends on what type of tables you are using how easy that would be.

baye · Feb 15, 2002

thegman,
Thanks for your help I'll try your sugestion and see how I go.

Thanks Again...

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Auto number in a replica database ?

baye

Technical User

thegman

Programmer

baye

Technical User

Similar threads

Part and Inventory Search

Sponsor