10mas
Posts: 3
|
| Posted: 08/28/2007, 12:33 PM |
|
Hello, I use the following code to launch a stored procedure with a parameter:
Dim sSQL
Dim myParameter
DIM strPolicyType
Dim DBConnection1
Set DBConnection1 = New clsDBConnection1
DBConnection1.Open
myParameter = "13232"
sSQL= "EXEC UnValidateStudy;1 " & myParameter
DBConnection1.Execute(sSQL)
If DBConnection1.State = adStateOpen Then DBConnection1.Close
Set DBConnection1 = Nothing
when I put this code into the Button1_BeforeShow(Sender) Function the procedure is launched but when I put the code onto Button1_OnClick(Sender) 'Button1_OnClick Function the procedure doesn´t work.
Any solution?
thanks in advance
|
 |
 |
|
