2 Replies Latest reply on Jul 21, 2012 4:55 AM by 786797

    Error 3001

    786797
      Does someone know what i am doing wrong here?

      i get an error 3001: Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another which is coming from the last line below..?

      'Initialize ADO objects
           Set rsAcct = CreateObject("ADODB.Recordset")
           
           'Generate Account sql string
           strSQLAcct = "SELECT Account FROM dbo.TG_Account"

           'Intiialize the block processor (Pass Active API & Script object References)
           Set objBP = CreateObject("upsWBlockProcessorDM.clsBlockProcessor")
           objBP.Initialize API, SCRIPTENG
           
           'Call the Connect Action of the integration block to connect to the TG Table
           Set API.IntBlockMgr.IntegrationMgr.PobjIntegrate = objBP.ActConnect("AfterValidate")
           
           'Open Account recordset using the varCon property of the block processor as the connection
           rsAcct.Open strSQLAcct, API.IntBlockMgr.IntegrationMgr.PobjIntegrate.varCon, 3, 1