Auto numbers

How can I make my form to create an autonumber to my table when I insert a new record. Is there any field in the table similar to autonumber field in MSACCESS. Please help!You have to set your colum field as an "identity" field.

You can do it in Enterprise Manager.

At the Design Table form, select "int" or a numeric field, I guess. And set your identity to "Yes not for replication"

Identity Seed=1 (Identity seed is your starting number)
Identity Increment=1 ( is the incremental number , auto inserted everytime there is a new record).

If you want T-SQL command , read it under "identity" in BOL.|||Thanks I am going to try it.

Originally posted by Patrick Chua
You have to set your colum field as an "identity" field.

You can do it in Enterprise Manager.

At the Design Table form, select "int" or a numeric field, I guess. And set your identity to "Yes not for replication"

Identity Seed=1 (Identity seed is your starting number)
Identity Increment=1 ( is the incremental number , auto inserted everytime there is a new record).

If you want T-SQL command , read it under "identity" in BOL.|||Thanks you really help me. Now I find another problem. When I am in my main page I got links for administrator, clients, ect... this links are for entering data, delete and update. If I am in the clients area for example, if I view a record information and then go to anoter record the page does not displays, I got to go to my home page and then go to the page that I was looking and it displays the information. Hope you can help me whis this one.

Originally posted by Patrick Chua
You have to set your colum field as an "identity" field.

You can do it in Enterprise Manager.

At the Design Table form, select "int" or a numeric field, I guess. And set your identity to "Yes not for replication"

Identity Seed=1 (Identity seed is your starting number)
Identity Increment=1 ( is the incremental number , auto inserted everytime there is a new record).

If you want T-SQL command , read it under "identity" in BOL.|||well, you have to tell us how you wrote the code to your application,
else we will be firing blank gueses to your question.

Although I do that often :)

What programing language are u using? ASP vbscript? and how do you query your database ? via ADO ?

Things like this will help us help u.

Auto Number SQL Server 2000

Hi all,

How can i generate auto Number in SQL Server 2000,like AutoNumber Datatype in MsAccess...

Thanx in advance

Sajjad

UseIDENTITY

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_create2_8g9x.asp

|||

Hi

Here is how you can do that with WebMatrix, from theGuided Tour

Using IsIdentity

Auto Number mysql

I have just moved over to mysql as the back end and keeping access as
front end. My database is for a ordering system. I use autonumber as
the Order Number. as mysql does not display the order number
(autonumber) until the form has been saved.
Is there a way on the order form that i can have a button that will
save the data then reopen the form so the order number ( autonumber is
displayed)
I am currently only learning about access so some nice easy instruction
would be very helpful
Thanks
SimonUm, this isn't a MySQL newsgroup. It's a SQL Server newsgroup. They are
different products.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
.
<S.Dickson@.shos.co.uk> wrote in message
news:1162900496.357948.305300@.b28g2000cwb.googlegroups.com...
I have just moved over to mysql as the back end and keeping access as
front end. My database is for a ordering system. I use autonumber as
the Order Number. as mysql does not display the order number
(autonumber) until the form has been saved.
Is there a way on the order form that i can have a button that will
save the data then reopen the form so the order number ( autonumber is
displayed)
I am currently only learning about access so some nice easy instruction
would be very helpful
Thanks
Simon

Auto Number mysql

I have just moved over to mysql as the back end and keeping access as
front end. My database is for a ordering system. I use autonumber as
the Order Number. as mysql does not display the order number
(autonumber) until the form has been saved.
Is there a way on the order form that i can have a button that will
save the data then reopen the form so the order number ( autonumber is
displayed)
I am currently only learning about access so some nice easy instruction
would be very helpful
Thanks
SimonUm, this isn't a mysql newsgroup. It's a SQL Server newsgroup. They are
different products.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
.
<S.Dickson@.shos.co.uk> wrote in message
news:1162900496.357948.305300@.b28g2000cwb.googlegroups.com...
I have just moved over to mysql as the back end and keeping access as
front end. My database is for a ordering system. I use autonumber as
the Order Number. as mysql does not display the order number
(autonumber) until the form has been saved.
Is there a way on the order form that i can have a button that will
save the data then reopen the form so the order number ( autonumber is
displayed)
I am currently only learning about access so some nice easy instruction
would be very helpful
Thanks
Simon