Passing... Variables

Results 1 to 2 of 2

Thread: Passing... Variables

  1. #1
    Papa Zito Guest

    Default Passing... Variables

    How do you pass variables to a stored procedure again?

  2. #2
    Join Date
    Dec 1969

    Default RE: Passing... Variables

    create a db connection, create a command object, set params and execute.<BR><BR>Example:<BR><BR><BR> objCMD.ActiveConnection = strSQLOLEDB<BR> objCMD.CommandText = "sp_add_product"<BR> objCMD.CommandType = adCmdStoredProc<BR> objCMD.Parameters.Refresh<BR> objCMD.Parameters(1).Value = product_id<BR> objCMD.Parameters(2).Value = source<BR> objCMD.Parameters(3).Value = valid_from<BR> .<BR> .<BR> .<BR> Set TempNonSessionVar = objCMD.Execute()<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts