CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2006
    Posts
    635

    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.

  2. #2
    Join Date
    Apr 2005
    Posts
    159

    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
  •  





Click Here to Expand Forum to Full Width

Featured