Results 1 to 2 of 2

Thread: [vb6] clear cmd object parameter

  1. #1

    Thread Starter
    Fanatic Member
    Join Date
    Jul 2007
    Posts
    617

    [vb6] clear cmd object parameter

    what is the equivalent code to clear command object parameters. this work in vb.net cmd.parameters.clear() but not in vb6.

  2. #2
    Frenzied Member
    Join Date
    Jul 2007
    Posts
    1,306

    Re: [vb6] clear cmd object parameter

    Are you talking about ADODB command object?
    If so try like this

    Code:
    Dim cmd As New ADODB.Command
        Dim param As New ADODB.Parameter
        Dim i As Integer
        
        param.Name = "test"
        param.Type = adBigInt
        cmd.Parameters.Append param
        For i = 0 To cmd.Parameters.Count - 1
            cmd.Parameters.Delete (i)
        Next
    IIF(Post.Rate > 0 , , )

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