Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2002

    Unanswered: Changing the start value for auto-increment field

    Hi all,

    Hopefully this is an easy question for one of you gurus. I have an auto-increment field, and I would like the start value to be different than 1 (Because it will later be migrated to SQL Server, along with another database collecting the same data, and we don't want to end up with duplicate keys). Any thoughts or assistance are appreciated.

    Thanks in advance for the help!

  2. #2
    Join Date
    Aug 2002
    Québec, Canada
    If your second database have an auto-increment key, you'll not end with duplicates key. The first record (with the number 1) will have his value auto-incremented to whatever your second database field is at, so it could become 546 if your second database have 545 datas in it


  3. #3
    Join Date
    Oct 2002
    NSW Australia


    you can run an update query on your table to update the autonumber to 1 less than the next number you want to use.

  4. #4
    Join Date
    Nov 2001
    In such case you can give up using autoincrement datatype and use long integer instead. Then write your own routine to increment the value in this field.

    HTH, Igor

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts