Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Get newest primary key immediately after db insert

Status
Not open for further replies.
new2unix

new2unix

Programmer
Feb 5, 2001
143
US
Hi,

How would I retrieve the newest primary key (an autonumber field in a SQL7 db) immediately after a conn.execute insert command is executed?

Thanks,

Mike
 
Sort by date Sort by votes
Look into using the @@Identity property. Searching this forum for '@@Identity' will give you many results, like thread709-638213.

zemp
 
Upvote 0 Downvote
Please see this thread too ...

thread183-906124

I was standing in the park, wondering why frisbees got bigger as they came closer... then it hit me!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

sal21
  • Locked
  • Question
get value from html page 1
Replies
7
Views
387
strongm
strongm
sal21
  • Question
NOT FOR ME, get value from table web
Replies
1
Views
206
sal21
sal21
sal21
  • Locked
  • Question
API REST get zip cod efrom street name and city
Replies
1
Views
285
strongm
strongm
sal21
  • Locked
  • Question
get controll type, controll name from the second panel of SStab 1
Replies
4
Views
796
strongm
strongm
2009luca
  • Locked
  • Question
GET date from classname
Replies
2
Views
484
2009luca
2009luca

Part and Inventory Search

Sponsor

Back
Top