Error in insert query!!

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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




Bhavna said:
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
Click to expand...
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
Click to expand...
and that it has been verifed against the datasource.
 
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
Click to expand...
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
Click to expand...
the syntax is ok and that it has been verifed against the
datasource.
 
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
 
Back
Top