Retrieve Field value of newly inserted record
I'm running a VBScript application which inserts a record into a table.
Scheme:
UserID (Identity field that auto increments for each insert)
Name
Email
I'd like to get the UserID of the newly inserted field.
How best can I achieve that?
Thanks in advance.
Scheme:
UserID (Identity field that auto increments for each insert)
Name
I'd like to get the UserID of the newly inserted field.
How best can I achieve that?
Thanks in advance.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I was able to find and tweak this code to get it done:
http://www.4guysfromrolla.com/webtech/100598-1.shtml
Steve