ASP get new Record ID value method _ Application Tips

asp+access2000

1. The ID Value field property to get must be set to: AutoNumber (we assume the field name is RecordID)
2. Add record format: Rs.Open table,cn,1,3
Note Mode is: 1,3
3.newID = Rs. Fields ("RecordID")
4.newID for the ID value of the record you just added

Asp+sql Server 2000

1. The ID Value field property to get must be set to: AutoNumber (we assume the field name is RecordID)
2. Add record code mode:

Copy Code code as follows:

Cn.execute INSERT into table (Field1,field2,...) VALUES ("Field1value", "Field2value",...) "

3. Get ID Value

Copy Code code as follows:

Set Rss = Cn.execute ("Select Scope_identity () as newidvalue from table")
' Rs.Open sqlstr,cn,3,1
NewID = Rss ("Newidvalue")

4.newID for the ID value of the record you just added
5. Attach three ways to obtain the ID value:

Copy Code code as follows:

/* The best use of ident_current (' Tbname ') for the ID to be generated by the last insert in a table.
INSERT into table (Field1,field2,...) VALUES ("Field1value", "Field2value",...) SELECT ident_current (' RecordID ') as Newidvalue

/* The scope_identity () is the most appropriate for the new record ID just inserted in the immediate use.
INSERT into table (Field1,field2,...) VALUES ("Field1value", "Field2value",...) SELECT scope_identity () as Newidvalue

/* It is best to use the @ @IDENTITY/* For the last ID that you want to get from a series of operations
INSERT into table (Field1,field2,...) VALUES ("Field1value", "Field2value",...) SELECT @ @IDENTITY as Newidvalu