I use Scope_Identity() in a lot of stored procedures to pass the
newwly inserted record's unique ID to the next select statement in the
same stored procedure.
What I'm wondering is how I can pass the Scope_Identity back to the
calling application.
I'm hoping someone can show me the SP code and the aceess code needed
to accomplish the following:
I insert a new record in a table with a stored procedure. The SP
passes the uniqueID (Scope_Identity) back to MS Access, then MS Access
uses the uniqueID when calling another function...
thanksHi
Check out the following that shows how to use stored procedures and output
parameters.
http://msdn.microsoft.com/library/d...html/sa00i8.asp
John
"Lauren Quantrell" <laurenquantrell@.hotmail.com> wrote in message
news:47e5bd72.0407170829.39971192@.posting.google.c om...
> I'm using an Access2K front end on a SQL Server2K backend.
> I use Scope_Identity() in a lot of stored procedures to pass the
> newwly inserted record's unique ID to the next select statement in the
> same stored procedure.
> What I'm wondering is how I can pass the Scope_Identity back to the
> calling application.
> I'm hoping someone can show me the SP code and the aceess code needed
> to accomplish the following:
> I insert a new record in a table with a stored procedure. The SP
> passes the uniqueID (Scope_Identity) back to MS Access, then MS Access
> uses the uniqueID when calling another function...
> thanks
No comments:
Post a Comment