Results 1 to 1 of 1

Thread: Help lookups

  1. #1
    Join Date
    Jun 2003
    Posts
    9

    Exclamation Unanswered: Help lookups

    Hi everyone,
    Iīm having a problem in DTS
    I have the following code in active X

    ---------------------------------------------
    .......(alredy tested code)....
    ------------------------------
    ERROR

    if (DTSSource("UND_FUNCIONAL") <>DTSLookups("existe_loja").execute(DTSSource("UND _FUNCIONAL") ) )Then
    Main = DTSTransformstat_InsertQuery
    end if
    End Function
    ..................
    ------------------------------------------------
    Lookups
    SELECT und_funcional
    FROM LOJA_DM
    WHERE (und_funcional = ?)
    -------------------------------------------
    Error message:
    ----DTSTransformStatus Value or an ActiveX did not return an integral type



    Kind Regards,
    Lucinda
    Last edited by LULU; 07-15-03 at 08:57.

Posting Permissions

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