CMD NamedParameters

From: Price Brattin (pbrattin_at_bigfoot.com)
Date: 02/21/04

  • Next message: Price Brattin: "Parameterized Queries" 
    Date: Sat, 21 Feb 2004 13:47:23 -0800

    Thank you, Picine. It now runs without error messages
    but it does not change any data. Any other ideas?

    >-----Original Message-----
    >Your CommandText should be:
    >Cmd.CommandText = "Declare @NewID VarChar(10), @OldID
    >VarChar(10)" & VbCrLf _
    > & "Update Time*** Set EmpID = @NewID
    >Where EmpID = @OldID "
    >
    >
    >>-----Original Message-----
    >>I execute the following code in ADO 2.8 and SQLServer
    >>returns the error "Must Declare Variable @NewID" on the
    >>Cmd.Execute. What am I doing wrong?
    >>
    >>Cmd.Connection = ADOConn
    >>Cmd.Name = "UpDateTbl"
    >>Cmd.Prepared = True
    >>Cmd.NamedParameters = True
    >>Cmd.CommandText = "Update Time*** " _
    >> & Set EmpID = @NewID Where EmpID = @OldID "
    >>Cmd.Parameters.Append Cmd.CreateParameter("@NewID", _
    >> adVarChar, adParamInput, 10)
    >>Cmd.Parameters.Append Cmd.CreateParameter("@OldID", _
    >> adVarChar, adParamInput, 10)
    >>
    >>Cmd("@NewID") = "0010"
    >>Cmd("@OldID") = "SmithBob"
    >>
    >>Cmd.Execute
    >>
    >>
    >>.
    >>
    >.
    >

  • Next message: Price Brattin: "Parameterized Queries"