Re: primary key autoincrement question.

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: jaYPee (hijaypee_at_yahoo.com)
Date: 04/06/04 

Date: Tue, 06 Apr 2004 17:11:32 +0800

Thank you for the reply. however i can't find an autoincrementing
properties under column properties in order to set it to false.

under column properties of IDNO field i have i only see this
properties:

Description
Default Value
Precision
Scale
Identity
Identity Seed
Identity Increment
Is RowGuid
Formula
Collation

i presume before and until now that i have to set the identity to "no"
but still in my vb.net app when i add record the IDNO field still
increment to the last value + 1.

don't know where can i set the autoincrement to "false"

thanks again

On Tue, 6 Apr 2004 09:41:21 +0200, "EricJ"
<ericReMoVe@ThiSbitconsult.be.RE> wrote:

>go to design, select your id make shure that there is a key symbol next to
>it (if not right click and set primary key)
>this makes it the primary key the identity is something else -->
>autoincrementing set it to false and there you go :)
>
>hope it helps
>
>eric
>
>"jaYPee" <hijaypee@yahoo.com> wrote in message
>news:8vl470phkea0fueivehemm3h882ousjg8f@4ax.com...
>> I have a table in my sqlserver 2000 that has a field IDNO. i want this
>> field to be my primary key. however i don't want this field to use the
>> autoincrement feature. when i access this table from vb.net and try to
>> add a record this field is autoincrementing. how can i disable the
>> autoincrement of this field yet serves this as my primary key?
>>
>> thanks in advance
>

Relevant Pages

  • Re: Can and Cant insert using DAO on SQL Server linked table
    ... is set to Yes for the Primary Key which is autoincrementing. ... Mark ... >> God Bless, ...
    (microsoft.public.sqlserver.security)
  • Re: Strange problem
    ... 150 records in it, with an autoincrementing ... >id-field, called ArchiveID as the primary key. ... If you are using a TadoTable set the Indexname to the index of your Primary key ...
    (borland.public.delphi.database.ado)
  • Re: primary key autoincrement question.
    ... select your id make shure that there is a key symbol next to ... it (if not right click and set primary key) ... this makes it the primary key the identity is something else --> ... > add a record this field is autoincrementing. ...
    (microsoft.public.dotnet.languages.vb)