Click here to Skip to main content
       

Database

 
GeneralRe: Database PinmemberMember 961179523-Feb-13 2:05 
GeneralRe: Database PinmemberS Douglas28-Feb-13 8:58 
AnswerRe: Database PinmemberJörgen Andersson22-Feb-13 12:11 
AnswerRe: Database PinmemberPIEBALDconsult22-Feb-13 14:38 
QuestionSQL Server + Procedure or function has too many arguments specified PinmemberHemant Thaker21-Feb-13 19:53 
AnswerRe: SQL Server + Procedure or function has too many arguments specified PinmvpSandeep Mewara21-Feb-13 20:00 
AnswerRe: SQL Server + Procedure or function has too many arguments specified PinmemberMycroft Holmes21-Feb-13 21:29 
AnswerRe: Resolved --> SQL Server + Procedure or function has too many arguments specified PinmemberHemant Thaker21-Feb-13 23:11 
Thanks for your responses.
 
Error is resolved, that was more logical.
 
I was creating Command object at class level, and adding parameters to it in remainderMailtimer_Elapsed().
This event will execute on timer interval.
 
So when it executes first time it find one parameter and runs successfully.
after 3 minutes interval it executes event for the second time and adds same parameter to it.
 
so now command object will have two parameters and corresponding SP has one. So it was throwing error.
 
I changed the code and created command object at event level.
 
Thanks.
By:
Hemant Thaker

QuestionDual Primary Key? PinmemberRichard.Berry10021-Feb-13 7:25 
AnswerRe: Dual Primary Key? PinmvpEddy Vluggen21-Feb-13 8:10 
GeneralRe: Dual Primary Key? PinmemberRichard.Berry10021-Feb-13 8:42 
GeneralRe: Dual Primary Key? PinmvpEddy Vluggen21-Feb-13 9:32 
GeneralRe: Dual Primary Key? PinmemberMycroft Holmes21-Feb-13 13:08 
GeneralRe: Dual Primary Key? PinmemberPIEBALDconsult21-Feb-13 19:14 
GeneralRe: Dual Primary Key? PinmvpEddy Vluggen21-Feb-13 23:42 
Questionjdbc PinmemberDurgesh1704r15-Feb-13 21:24 
AnswerRe: jdbc PinmvpRichard MacCutchan15-Feb-13 23:31 
AnswerRe: jdbc PinmemberMycroft Holmes16-Feb-13 16:21 
QuestionOlder generation SQL syntax - Oracle Pinmembervanikanc13-Feb-13 3:37 
AnswerRe: Older generation SQL syntax - Oracle PinmemberJörgen Andersson13-Feb-13 11:30 
GeneralRe: Older generation SQL syntax - Oracle Pinmembervanikanc13-Feb-13 11:37 
AnswerRe: Older generation SQL syntax - Oracle PinmemberShameel15-Feb-13 5:17 
QuestionHaving a bad SQL day PinmemberTheComputerMan13-Feb-13 0:40 
AnswerRe: Having a bad SQL day PinmemberJörgen Andersson13-Feb-13 1:20 
GeneralRe: Having a bad SQL day PinmemberTheComputerMan13-Feb-13 1:32 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web04 | 2.8.141216.1 | Last Updated 18 Dec 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid