auto generate number in data base creates negative numbers in vb.net how to make it working perfectly.i am using vb.net using databindings please help me

Re: auto generate number in data base creates negative numbers in vb.net 80 80

What database are you using? What are the settings for the auto-generate column?

Re: auto generate number in data base creates negative numbers in vb.net 80 80

i am using ms access 2003 database. i am just using the autogenarate column directly from access as invoice number in vb.net when i am adding any data it automatically shows negative numbers like -1,-2,-3 and so on why this happenning i just dont understand

Re: auto generate number in data base creates negative numbers in vb.net 80 80

For an auto increment field in Access you should have

Field Size: Long Integer
New Values: Increment

does that match what you have? What is the value of that column in the first database record?

Re: auto generate number in data base creates negative numbers in vb.net 80 80

Field Size: Long Integer
New Values: Increment both are ok in my database i have a products table having data irst column is

1 Invoice No=autonumber which is auto incremented then
2 product name=text,
3 name=text ,
4 date of issue=date/time,
5 quantity=text,
6 price=text
7 grand total=text

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.19 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.