-
September 12th, 2006, 11:18 AM
#1
ADODB.Command Help
I have a function return cursor, I use ADODB.command to call function.
my problem is : What data type is? in parameters that return cursor
Code:
Private Sub Command1_Click()
Dim rst As New ADODB.Recordset
Dim cmd As New ADODB.Command
Set cmd = New ADODB.Command
With cmd
.ActiveConnection = Str_cnn
.CommandText = "returncursor"
.CommandType = adCmdStoredProc
.Parameters.Append .CreateParameter("v", 'Here What data type is?', adParamReturnValue)
.Parameters.Append .CreateParameter("val1", adVarChar, adParamInput, 225, "select * from table")
.Execute
Set rst = .Parameters("v").Value
End With
Set cmd = Nothing
End Sub
It work on SQL server or postgresql
Last edited by hensa22; September 12th, 2006 at 11:20 AM.
-
September 14th, 2006, 03:31 AM
#2
Re: ADODB.Command Help
plz expalin a little bit in more details?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|