hi guys,
i am using the vb 2005 to create an application and i created a database from the vb by adding a new Item(Database).
i want to know how can i make the id wich is a number,to take an auto number and not to have to enter it with my insert statment.
I know in oracle i use a sequence and in access i use Auto Number as a type for the field,i want somthing like this here
thank you.
Commando123 0 Newbie Poster
alc6379 120 Cookie... That's it Team Colleague
What is your underlying database, exactly? Access and SQL both have an "Identity" field type which you can specify autoincrement there.
The Database type doesn't really do that, unless I'm mistaken. You still have to have a database somewhere, and define your schema in it.
Commando123 0 Newbie Poster
i added the data base from the vb it self, from the solution explorer, add new item. and i know the vb uses sql server.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.