Hey Guy,
I know this has been discussed before, probably about 1000 times, but I can't seem to find anything. As many of you have done before, I need to store a value that is the Next Number to be used for some purpose. Common uses would be customer number, order number, etc. What are some of the ways to do this, which would you think is easiest? This is really just a down and dirty type of thing that will only be needed for about the next year... I need to generate a Catalog Number... basically a 6 digit number, probably seeded above 100000. Is there some user space or something? Or use a file and increment with SQL? What do you think?
I know this has been discussed before, probably about 1000 times, but I can't seem to find anything. As many of you have done before, I need to store a value that is the Next Number to be used for some purpose. Common uses would be customer number, order number, etc. What are some of the ways to do this, which would you think is easiest? This is really just a down and dirty type of thing that will only be needed for about the next year... I need to generate a Catalog Number... basically a 6 digit number, probably seeded above 100000. Is there some user space or something? Or use a file and increment with SQL? What do you think?
Comment