19-Nov-2005, 21:59 PM
|  | Guest | | | | | | | | | | Re: Why does my autonumbered field not start at 0?
Laura,
If your table is empty, before adding any records to your table...
Compact the database.
Then the first record you enter should be 1.
--
hth
Al Camp
Candia Computer Consulting - Candia NH Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7728 http://home.comcast.net/~cccsolutionsReference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7728
"Laura" wrote in message
news:CA2C72D4-EF25-40C7-A998-9ADC68E32156@microsoft.com...
>I have created a table and as all of the other fields could potentially
>have
> repeats I am using a numbered ID as the primary key, this however is not
> starting at zero it keeps starting at 22? Can anybody please help?
|
19-Nov-2005, 22:00 PM
| | Guest | | | | | | | | | | Re: Why does my autonumbered field not start at 0?
Laura
If your Primary Key is used solely for identifying the record, does it
matter whether it starts at 1 or 22 or 12345? Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7728
Regards
Jeff Boyce
"Laura" wrote in message
news:CA2C72D4-EF25-40C7-A998-9ADC68E32156@microsoft.com...
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7728
>I have created a table and as all of the other fields could potentially
>have
> repeats I am using a numbered ID as the primary key, this however is not
> starting at zero it keeps starting at 22? Can anybody please help?
|
19-Nov-2005, 22:00 PM
| | Guest | | | | | | | | | | Re: Why does my autonumbered field not start at 0?
Hi Jeff,
That's one reason for my frequent rant that Autonumber datatypes
should absolutely, positively be used for nothing but surrogate keys
and that they should never, never, never be seen by humans. Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7728
--
-Larry-
--
"Jeff Boyce" wrote in message
news:%2364hxLK7FHA.3416@TK2MSFTNGP15.phx.gbl...
> Laura
>
> If your Primary Key is used solely for identifying the record, does
it
> matter whether it starts at 1 or 22 or 12345?
>
> Regards
>
> Jeff Boyce
>
>
> "Laura" wrote in message
> news:CA2C72D4-EF25-40C7-A998-9ADC68E32156@microsoft.com...
> >I have created a table and as all of the other fields could
potentially
> >have
> > repeats I am using a numbered ID as the primary key, this however
is not
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7728
> > starting at zero it keeps starting at 22? Can anybody please
help?
>
>
| 
Support Us! Become a Promoter! | | Gurfateh ji, you can become a SPN Promoter by Donating as little as $10 each month. With limited resources & high operational costs, your donations make it possible for us to deliver a quality website and spread the teachings of the Sri Guru Granth Sahib Ji, to serve & uplift humanity. Every contribution counts. Donate Generously. Gurfateh! |
 (View-All)
Members who have read this thread : 0
| | There are no names to display. |
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | | | | Tools | Search | | | | | Display Modes |  Linear Mode |
Posting Rules
| You may not post new threads You may not post replies You may not post attachments You may not edit your posts
HTML code is On
| | | |  | » Gurbani Jukebox |  Listen to Gurbani while surfing SPN! | | » Active Discussions | | | | | | |  ਨਾਮਾ Today 06:37 AM 2 Replies, 53 Views | | | | | | | | | | | | | | | | | | | | | | | | » Books You Should Read... | | | |
