Click here to Skip to main content
11,719,903 members (85,954 online)
   

Database

 
GeneralRe: Database Pin
Member 961179523-Feb-13 1:05
memberMember 961179523-Feb-13 1:05 
GeneralRe: Database Pin
S Douglas28-Feb-13 7:58
memberS Douglas28-Feb-13 7:58 
AnswerRe: Database Pin
Jörgen Andersson22-Feb-13 11:11
memberJörgen Andersson22-Feb-13 11:11 
AnswerRe: Database Pin
PIEBALDconsult22-Feb-13 13:38
memberPIEBALDconsult22-Feb-13 13:38 
QuestionSQL Server + Procedure or function has too many arguments specified Pin
Hemant Thaker21-Feb-13 18:53
memberHemant Thaker21-Feb-13 18:53 
AnswerRe: SQL Server + Procedure or function has too many arguments specified Pin
Sandeep Mewara21-Feb-13 19:00
mvpSandeep Mewara21-Feb-13 19:00 
AnswerRe: SQL Server + Procedure or function has too many arguments specified Pin
Mycroft Holmes21-Feb-13 20:29
memberMycroft Holmes21-Feb-13 20:29 
AnswerRe: Resolved --> SQL Server + Procedure or function has too many arguments specified Pin
Hemant Thaker21-Feb-13 22:11
memberHemant Thaker21-Feb-13 22: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? Pin
Richard.Berry10021-Feb-13 6:25
memberRichard.Berry10021-Feb-13 6:25 
AnswerRe: Dual Primary Key? Pin
Eddy Vluggen21-Feb-13 7:10
mvpEddy Vluggen21-Feb-13 7:10 
GeneralRe: Dual Primary Key? Pin
Richard.Berry10021-Feb-13 7:42
memberRichard.Berry10021-Feb-13 7:42 
GeneralRe: Dual Primary Key? Pin
Eddy Vluggen21-Feb-13 8:32
mvpEddy Vluggen21-Feb-13 8:32 
GeneralRe: Dual Primary Key? Pin
Mycroft Holmes21-Feb-13 12:08
memberMycroft Holmes21-Feb-13 12:08 
GeneralRe: Dual Primary Key? Pin
PIEBALDconsult21-Feb-13 18:14
memberPIEBALDconsult21-Feb-13 18:14 
GeneralRe: Dual Primary Key? Pin
Eddy Vluggen21-Feb-13 22:42
mvpEddy Vluggen21-Feb-13 22:42 
Questionjdbc Pin
Durgesh1704r15-Feb-13 20:24
memberDurgesh1704r15-Feb-13 20:24 
AnswerRe: jdbc Pin
Richard MacCutchan15-Feb-13 22:31
mvpRichard MacCutchan15-Feb-13 22:31 
AnswerRe: jdbc Pin
Mycroft Holmes16-Feb-13 15:21
memberMycroft Holmes16-Feb-13 15:21 
QuestionOlder generation SQL syntax - Oracle Pin
vanikanc13-Feb-13 2:37
membervanikanc13-Feb-13 2:37 
AnswerRe: Older generation SQL syntax - Oracle Pin
Jörgen Andersson13-Feb-13 10:30
memberJörgen Andersson13-Feb-13 10:30 
GeneralRe: Older generation SQL syntax - Oracle Pin
vanikanc13-Feb-13 10:37
membervanikanc13-Feb-13 10:37 
AnswerRe: Older generation SQL syntax - Oracle Pin
Shameel15-Feb-13 4:17
memberShameel15-Feb-13 4:17 
QuestionHaving a bad SQL day Pin
TheComputerMan12-Feb-13 23:40
memberTheComputerMan12-Feb-13 23:40 
AnswerRe: Having a bad SQL day Pin
Jörgen Andersson13-Feb-13 0:20
memberJörgen Andersson13-Feb-13 0:20 
GeneralRe: Having a bad SQL day Pin
TheComputerMan13-Feb-13 0:32
memberTheComputerMan13-Feb-13 0: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.150901.1 | Last Updated 4 Sep 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid