Retrieve a record number when doing an INSERT statement

by Mike Kendrick (1 Submission)
Category: Databases/Data Access/DAO/ADO
Compatability: VB 6.0
Difficulty: Unknown Difficulty
Originally Published: Fri 2^nd August 2002
Date Added: Mon 8^th February 2021
Rating: (1 Votes)

API Declarations
'This code assumes you have a database connection already created called DBConn 'And an auto-incrementing number field in your database 'I looked long and hard for a way to do this - this is the best i came up 'with - if you find a better way or have questions - shoot me an email.

Rate Retrieve a record number when doing an INSERT statement




'Your Insert Statement
SS$ = "INSERT INTO YOURTABLE (Field1, Field2) VALUES ('Value1','Value2')"

'Execute the INSERT and also retrieve the record number
Set rs = DBConn.Execute(SS$ & ";Select @@Identity as ident")
Set rs = rs.NextRecordset

'Set iRecNum = to the record number of the data you just inserted into the table
iRecNum = rs!Ident
rs.Close: Set rs = Nothing

Download this snippet Add to My Saved Code

Retrieve a record number when doing an INSERT statement Comments

No comments have been posted about Retrieve a record number when doing an INSERT statement. Why not be the first to post a comment about Retrieve a record number when doing an INSERT statement.

Retrieve a record number when doing an INSERT statement

Retrieve a record number when doing an INSERT statement Comments

Post your comment

Difficulty