|
Is there made an "forgotten password mailer" in the
past?
Tommy
----- Original Message -----
Sent: Saturday, October 21, 2000 9:03
PM
Subject: Re: [FreeTrade] Question about
ID numbers
Hi Shawn,
The id number thing is the same on any database I've ever used. It seems to
be the standard for auto incremented fields. The reason is simple. The program
has to assume there could be a parent child relationship with the ID. If you
delete something in the middle (or end) of your database, the resultant gap
could cause you big problems if the deleted number was replaced with something
new. I've been working with db's for 25 years, and I just ignore those gaps.
Can't help with the sku thing. I don't like it either.
Regards,
John
Shawn Honeychurch wrote:
Hi; Can someone tell me why after i delete all the items form my
database, when I add new items the ID numbers continue counting from where
they left off from the old items? Also how do i stop this from
happening? One other
question. How do i force the SKU numbers to be the same as the Item
numbers? I am not going to use multiple SKU's and would like the SKU's
and Items to match. Thanks Shawn
|
