Hi!
I need to execute my insert stored procedure more than once, when the stored procedure gets executed for the second time I get an error:
Procedure or function up_NewPricesInsert has too many arguments specified.
What should I do to execute the sp more than once?
PEACE!
Make sure that after you have run it the first time you clear the parameters!!
Are you doing transaction handling!!
make sure you do a commit as well....
Make sure that you are setting your ADODB.Command Object to Nothing before next insert ... as otherwise your code is just BE appending more parameters to your ADODB.COMMAND OBJECT
See code attached below where ADODB.Command is cmProc_spPhoneDirectoryInsert
Private Function Proc_spPhoneDirectoryInsert() As Boolean
On Error GoTo LocalError
' Create objects we need
Dim cmProc_spPhoneDirectoryInsert As ADODB.Command
Set cmProc_spPhoneDirectoryInsert = New ADODB.Command
' Setup stored procedure to call
cmProc_spPhoneDirectoryInsert.CommandType = adCmdStoredProc
cmProc_spPhoneDirectoryInsert.CommandText = "spPhoneDirectoryInsert"
' Assign Parameters
With cmProc_spPhoneDirectoryInsert
.Parameters.Append .CreateParameter("RETURN_VALUE", adInteger, adParamReturnValue)
.Parameters.Append .CreateParameter("@Surname", adChar, adParamInput, 2, PhoneDirectory.Surname)
.Parameters.Append .CreateParameter("@FirstName", adChar, adParamInput, 6, PhoneDirectory.FirstName)
.Parameters.Append .CreateParameter("@PhoneNumber", adChar, adParamInput, 6, PhoneDirectory.PhoneNumber)
End With
gobjDBAccess.ExecCommand cmProc_spPhoneDirectoryInsert
' Release local variables
Set cmProc_spPhoneDirectoryInsert = Nothing
Proc_spPhoneDirectoryInsert = True
LocalExit:
Exit Function
LocalError:
Proc_spPhoneDirectoryInsert = False
gObjError.GetErrorDetails "clsPhoneDirectorys::spPhoneDirectoryInsert"
gObjError.ReRaise
End Function
:( :)
Ke a leboga!
Thanks!
Quote:
Make sure that you are setting your ADODB.Command Object to Nothing before next insert
If you are executing the same command more than once it would be pointless and stupid (no offense), to clear the parameters and/or set the command object to nothing after each call to execute.Quote:
Make sure that after you have run it the first time you clear the parameters!!
Agreed..... just create the command once, create the parameters ONCE.... set them, execute it, reset the parameters, and execute again.....Quote:
Originally posted by brucevde
If you are executing the same command more than once it would be pointless and stupid (no offense), to clear the parameters and/or set the command object to nothing after each call to execute.