SQL Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
 
User Name:
Password:
Remember me
Go Back   ASP Free ForumsDatabaseSQL Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread ASP Free Forums Sponsor:
SlickEdit: Code in over 40 languages across 7 platforms. SlickEdit’s unmatched power, speed, and flexibility allows even the most accomplished developers to write better code faster. Download a free trial today!
  #1  
Old June 15th, 2000, 11:01 AM
Steve Schofield Steve Schofield is offline
Contributing User
ASP Free God 20th Plane (14500 - 14999 posts)
 
Join Date: Dec 2002
Posts: 14,578 Steve Schofield User rank is Corporal (100 - 500 Reputation Level)Steve Schofield User rank is Corporal (100 - 500 Reputation Level)Steve Schofield User rank is Corporal (100 - 500 Reputation Level)Steve Schofield User rank is Corporal (100 - 500 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 22
How to get the primary key right after insertion

<i><b>Originally posted by : Carol (cxi@frymulti.com)</b></i><br />This is always a question to me, hope somebody can give me help. <br /><br />If you have a table with an identity as the primary key, how to get the number out after you insert a row into the table. (under multiple users' situation). <br /><br />Thanks! <br />

Reply With Quote
  #2  
Old June 19th, 2000, 04:54 PM
Steve Schofield Steve Schofield is offline
Contributing User
ASP Free God 20th Plane (14500 - 14999 posts)
 
Join Date: Dec 2002
Posts: 14,578 Steve Schofield User rank is Corporal (100 - 500 Reputation Level)Steve Schofield User rank is Corporal (100 - 500 Reputation Level)Steve Schofield User rank is Corporal (100 - 500 Reputation Level)Steve Schofield User rank is Corporal (100 - 500 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 22
<i><b>Originally posted by : Carol</b></i><br />I got the answers. For those who are interested, please go to the following link:<br />http://www.aspfree.com/authors/briang/identitywithsql.asp<br /><br /><br />------------<br />Carol at 6/15/2000 9:01:09 AM<br /><br />This is always a question to me, hope somebody can give me help. <br /><br />If you have a table with an identity as the primary key, how to get the number out after you insert a row into the table. (under multiple users' situation). <br /><br />Thanks! <br />

Reply With Quote
  #3  
Old June 28th, 2000, 11:15 AM
Steve Schofield Steve Schofield is offline
Contributing User
ASP Free God 20th Plane (14500 - 14999 posts)
 
Join Date: Dec 2002
Posts: 14,578 Steve Schofield User rank is Corporal (100 - 500 Reputation Level)Steve Schofield User rank is Corporal (100 - 500 Reputation Level)Steve Schofield User rank is Corporal (100 - 500 Reputation Level)Steve Schofield User rank is Corporal (100 - 500 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 22
<i><b>Originally posted by : Axon (axon_omni@yahoo.com)</b></i><br />what is the varible that contains the ID?<br /><br /><br />------------<br />Carol at 6/19/2000 2:54:26 PM<br /><br />I got the answers. For those who are interested, please go to the following link:<br />http://www.aspfree.com/authors/briang/identitywithsql.asp<br /><br /><br />------------<br />Carol at 6/15/2000 9:01:09 AM<br /><br />This is always a question to me, hope somebody can give me help. <br /><br />If you have a table with an identity as the primary key, how to get the number out after you insert a row into the table. (under multiple users' situation). <br /><br />Thanks! <br />

Reply With Quote
Reply

Viewing: ASP Free ForumsDatabaseSQL Development > How to get the primary key right after insertion


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 1 hosted by Hostway