List:General Discussion« Previous MessageNext Message »
From:Román Sánchez Date:May 27 2003 4:31pm
Subject:Re: Auto decrement
View as plain text  
> Does anyone know if there is a way of setting an auto numbered field
> that starts at say 2,000,000 and decreases by one on each insert?

Well, if you know the starting number you can use a normal autoinc field and
retrieve the value you want by substracting:

2,000,000 - AutoIncField

Regards
Thread
• Select statement driving me crazyAnthony Ward27 May
  • Re: Select statement driving me crazyMaximo Migliari27 May
  • Re: Select statement driving me crazycolbey27 May
    • Re: Select statement driving me crazyMatthew Smith27 May
  • Re: Select statement driving me crazyAnthony Ward27 May
    • Re: Select statement driving me crazycolbey27 May
  • Re: Select statement driving me crazyAnthony Ward27 May
    • Re: Select statement driving me crazycolbey27 May
      • Auto decrementGary Broughton27 May
        • Re: Auto decrementRomán Sánchez27 May
    • Re: Select statement driving me crazyKeith C. Ivey27 May
  • Re: Select statement driving me crazyJames Moe28 May
• RE: Select statement driving me crazyMike Hillyer27 May
• Re: Select statement driving me crazyAnthony Ward27 May
• Re: Select statement driving me crazyAnthony Ward27 May
• RE: Select statement driving me crazyMike Hillyer27 May