Sequential numbering in the database.

Results 1 to 2 of 2

Thread: Sequential numbering in the database.

  1. #1
    Join Date
    Dec 1969

    Default Sequential numbering in the database.

    I am creating this application that will allow people to enter issues within certain project areas. I would like the issues to be numbered sequentially within each project grouping. I am thinking maybe that I need to grab the max value of the issues already in the db for a selected project, and then add one to that value for the creation of the new issue number. Does this sound reasonable, and if so...what functions should I use? If not reasonable, does anyone have suggestions?<BR><BR>Thanks in advance,<BR><BR>Grant

  2. #2
    Anton Bawab Guest

    Default RE: Sequential numbering in the database.

    Sound very reasonable.<BR><BR>As for the functions, I am not sure I understand what you mean. Depending on the SQL Backend you use, you might be able to get your max value with an SQL statement and simply use it PLUS one to define the new value.<BR><BR>Anton.

Posting Permissions

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