@@IDENTITY return after insert using access 2002
Posted on 2003-11-19
This is my SP in access 2002.
ALTER PROCEDURE dbo.AddList
INSERT INTO dbo.List
(ListTypeID, IDNum, Client)
VALUES (@ListTypeID, @IDNum, @Client)
SELECT @@IDENTITY as IDent
To run this as a test from access i just double clicked the SP from the list, It prompts me for the info. The data is inserted into the table correctly, but i get an error--
"The stored procedure executed successfully but did not return records."
How do I get the ID of the inserted record?