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"
<er********@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" <hi******@yahoo.com> wrote in message
news:8v********************************@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