Member Avatar for sas0riza

Hi,
In my Insert SP, I have 5 local variables:
@MemberID int,
@VideoID int,
@Total money,
@DateRented datetime,
@DateDue datetime

insert into RentalRecord
values (@MemberID,@VideoID,@Total,GETDATE(), DATEADD(dd,5,GETDATE()))


When I try to execute the SP, I get this error:
Procedure or function 'sp_AddRentalRecord' expects parameter '@DateRented', which was not supplied.

Please advise.

Thanks

  • 3 Contributors
  • 2 Replies
  • 92 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by dickersonka
Member Avatar for peter_budo

Would be nice if you could share your solution of the problem...

Member Avatar for dickersonka

not for sure, but i would say because that parameter was never used and i figure he took it out

@DateRented become GetDate()
@DateDue become GetDate() + 5

so i believe he originally had them in the stored procedure as parameters, and then removed them to fix the problem, as they weren's used

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.