Insert new rec, then pass new identity val back to Access97 
Author Message
 Insert new rec, then pass new identity val back to Access97

I am developing an aplication using Access 97 and SQL 6.5

I have successfuly created a strored procedure using parameters passed into
it that are inserted into a new record.

HOW do I grab the new value of the identity column and pass it back to
Access?

Any help would me most gratefully appreciated!
Thanks!

Here is my stored procedure so far:


As

INSERT INTO  tblHtlRmRequest (HRR_PaGr_ID, HRR_HotelID, HRR_TotalNoRooms,
HRR_DateRequested, HRR_Notes)


return (0)

George Padvorac



Fri, 30 Jun 2000 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. New Rec with previous Rec data

2. Perform a go to new rec w/ retaining some info from prev rec

3. Move to newrecord adds rec to db, but cant move to new rec

4. New Rec with previous Rec data

5. New Rec with Data Based on Previous Rec's Data

6. Enter Val Form1, Open Form2 insert Val

7. finding the new identity after an insert

8. finding the new identity after an insert

9. finding the new identity after an insert

10. finding the new identity after an insert


 
Powered by phpBB® Forum Software © phpBB Group