Data enviroment run time error
hello!
first I want to thank everybody for answering my questions. I found this forum very helpful.
New problem I ran into:
When I am trying to execute store procedures with optional parameters i am getting run time error:
"Prepared statement '(@P1 int output, @P1 int) EXEC
@P1 = dbo.spSeect' expects parameter @P2,
which was not supplied"
Error handling doesn't help. even if I specify exact Err.Number
In the end of the following code is the place where error executes:
With oDeVe.Commands ("dbo_RptGEN_SelectTransactionList").Parameters
.Refresh
If Not oReport.Batch = 0 Then
.Item("@Batch") = oReport.Batch
End If
End With
oDeVe.Commands("dbo_RptGEN_SelectTransactionList").Execute
---------
mybe somebody had the same issue or can refer me into right direction or (even better) fix it. :-))
Thanks