Results 1 to 5 of 5

Thread: Auto numbers

  1. #1
    Join Date
    Sep 2002
    Location
    San Juan, Puerto Rico
    Posts
    29

    Unanswered: 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!

  2. #2
    Join Date
    Jul 2003
    Location
    Penang, Malaysia
    Posts
    212
    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.
    Patrick Chua
    LBMS ( Learn By My Self) NPQ ( No paper Qualification )

  3. #3
    Join Date
    Sep 2002
    Location
    San Juan, Puerto Rico
    Posts
    29

    Auto number increment

    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.

  4. #4
    Join Date
    Sep 2002
    Location
    San Juan, Puerto Rico
    Posts
    29

    Auto number increment

    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.

  5. #5
    Join Date
    Jul 2003
    Location
    Penang, Malaysia
    Posts
    212
    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.
    Last edited by Patrick Chua; 08-21-03 at 19:11.
    Patrick Chua
    LBMS ( Learn By My Self) NPQ ( No paper Qualification )

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •