Touble with ASP INTERDEV SQL Query

[bryant89]

I am having trouble with an sql query in interdev.

I am trying to retrieve the identity using the @@IDENTITY value but for some reason it will not work.
Here is my code

Alter Procedure stpCreateReturn

@copName varchar(70),
@copCity varchar(40),
@copProv char(2),
@copCountry varchar(30),
@copAddress varchar(70),
@copStatus varchar(70),
@copEstCost money

AS

INSERT INTO tblContProj (copName, copCity, copProv, copCountry, copAddress, copStatus, copEstCost)
VALUES (@copName, @copCity, @copProv, @copCountry, @copAddress, @copStatus, @copEstCost)

SELECT @@IDENTITY
GO
return


The insert works fine but the select does not.
Any help would be Appreciated

Bryant

 

[Guest_imported]

Try this link

http://www.kamath.com/tutorials/tut007_identity.asp

You'll find a detailed explanation on how to overcome this problem

 

[bryant89]

thanks for the tip.

I will check it out