Error in insert query!!

[Guest]

Hello

I am tying to create an insert stored procedure in my access project (MSDE)
I am trying to retrieve the autonumber primary key value that is generated by the insert after this. This is my code..

INSERT INTO dbo.Ren
(Lname, Fname, RentAddress, RentPostcode, PhoneNo
VALUES (@Lname, @Fname, @Address, @Postcode, @PhoneNo
SELECT RentI
FROM dbo.Ren
WHERE (RentID = SCOPE_IDENTITY()

When i click the verify sql i get a message stating that the syntax is ok and that it has been verifed against the datasource
However when i try to save the query i get a message stating:
ADO error:Must declare the variable '@Surname

what must i do to correct this

 

[Michel Walsh]

Hi,


Try to recreate a new stored procedure. I think there is a problem with
the "management" of your actual stored procedure, after you changed it...


Hoping it may help,
Vanderghast, Access MVP

Hello,

I am tying to create an insert stored procedure in my access project (MSDE).
I am trying to retrieve the autonumber primary key value that is generated

by the insert after this. This is my code...

INSERT INTO dbo.Rent
(Lname, Fname, RentAddress, RentPostcode, PhoneNo)
VALUES (@Lname, @Fname, @Address, @Postcode, @PhoneNo)
SELECT RentID
FROM dbo.Rent
WHERE (RentID = SCOPE_IDENTITY())

When i click the verify sql i get a message stating that the syntax is ok

and that it has been verifed against the datasource.

 

[Harvey]

You use the name @lname in your code and the error is
calling for @surname. Are your names all correct?

-----Original Message-----
Hello,

I am tying to create an insert stored procedure in my access project (MSDE).
I am trying to retrieve the autonumber primary key value

that is generated by the insert after this. This is my
code...

INSERT INTO dbo.Rent
(Lname, Fname, RentAddress, RentPostcode, PhoneNo)
VALUES (@Lname, @Fname, @Address, @Postcode, @PhoneNo)
SELECT RentID
FROM dbo.Rent
WHERE (RentID = SCOPE_IDENTITY())

When i click the verify sql i get a message stating that

the syntax is ok and that it has been verifed against the
datasource.

 

[fofa]

So where is this variable @SurName? I have the feeling we are not seein
all the code here. Also are there any insert triggers on the table