-----------------------------------------------------------
New Message on MumbaiUserGroup
-----------------------------------------------------------
From: omsss
Message 5 in Discussion
My stored Procedure is CREATE procedure Checkid1
(
@name1 Varchar(40)
)
as
if exists (select * from test_Del where [EMAIL PROTECTED])
return(1)
else
return(0)
GO Vb-code Dim conn As New ADODB.Connection
Dim cmd As New ADODB.Command
Private Sub Form_Load()
conn.Open "Mydsn", "sa", "444"
Set cmd = New ADODB.Command
Set param = New ADODB.Parameter cmd.ActiveConnection = conn
cmd.CommandText = "Checkid1"
cmd.CommandType = adCmdStoredProc Set param = cmd.CreateParameter("@name1", adVarChar,
adParamInput, 7, "pradeep")
cmd.Parameters.Append param
cmd.Parameters(0).Value = "Pradeep"
Set rs = cmd.Execute If Not rs.EOF Or rs.BOF Then
Do While Not rs.EOF
MsgBox rs("test_id")
rs.MoveNext
Loop
End If Do While Not rs.EOF-- display error here
msgbox rs(0) rs.MoveNext
Loop
End Sub
Run time Error Error: operation is not allowed when object is closed what is
wrong with this code It disply operation not allowed it is closed Help Me
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/MumbaiUserGroup/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you received
this message by mistake, please click the "Remove" link below. On the pre-addressed
e-mail message that opens, simply click "Send". Your e-mail address will be deleted
from this group's mailing list.
mailto:[EMAIL PROTECTED]
