asked on

STORED PROC @@IDENTITY OUTPUT PARAMETER

Does anyone know how in my Proc where I am doing an Insert statement return that new identity number to my ADO Code. Could you please just give me an example on how to do this. The way I do my stored proc currently is
strsql = "spInsertNew"
CurrentProject.Connection.Execute

I guess I will need to change this a little to get the output parameter.

Thanks all

ASKER CERTIFIED SOLUTION

dtomyn

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Paurths

Hi bostonroxx,

u been asking 8 Q's in 10 days, and have not graded 1.
Didn't anyone provide a correct comment?

u should follow up on your Q's. Experts put in time and effort for u, u know!

cheers
Ricky

cjswimmer

bostonroxx, you abandoned the questions:

https://www.experts-exchange.com/jsp/qShow.jsp?ta=msaccess&qid=20144642
https://www.experts-exchange.com/jsp/qShow.jsp?ta=msaccess&qid=20152587
https://www.experts-exchange.com/jsp/qShow.jsp?ta=msaccess&qid=20151748
https://www.experts-exchange.com/jsp/qShow.jsp?ta=msaccess&qid=20143487
https://www.experts-exchange.com/jsp/qShow.jsp?ta=mssql&qid=20140652

as Paurths has already asked, please clean up your old questions.

cjswimmer

amp072397

Netminder

Admin notified of User neglect. Force-accepted by
Netminder
CS Moderator