|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
November 16th, 2000, 05:22 PM
|
|||
|
|||
|
how to update 2 tables using using stored procedure
<i><b>Originally posted by : asiya (asiya@talk21.com)</b></i><br />hi and help me pls<br />i am trying to insert data into 2 tables from an asp page using sql stored procedure, the problem am having is, i want to set the first table primary key as a foreign key in the second table<br />can you help me pls<br />thank you <br />asiya<br /><br />
|
|
#2
September 19th, 2003, 05:55 AM
|
|||
|
|||
|
It should be the other way round
a key (foreign) is related to a primary key give more details how does your stored procedure look because your stored procedure will do the actual work the fact that you want to access it from asp is not relevant in this context
|
|
#3
November 19th, 2003, 03:11 PM
|
|||
|
|||
You need to use the adOpenKeyset cursor type, then right after the update, you can pull the key from the inserted record.
|
|
| Viewing: ASP Free Forums > Database > SQL Development > how to update 2 tables using using stored procedure |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
