Forums Lawson S3 Financials

SQL QUERY NODE outputData

Author
Messages
Magus
Basic Member
Posts: 6
Basic Member
4/19/2016 8:55 AM
    Hello All,

    Am using a SQL QUERY NODE to query a table..But, the SQL QUERY NODE _ outputData is blank..



    Please anyone guide me to fetch the results of that query and send them to a directory..

    Lawson_Kid
    Basic Member
    Posts: 13
    Basic Member
    4/19/2016 7:55 PM
      Would you mind posting the SQL?
      Magus
      Basic Member
      Posts: 6
      Basic Member
      4/20/2016 4:04 AM
        Have no issues with Query..Its working fine and can see the results in log..

        my concern here is with , "SQLQuery2440_outputData = " ..
        Its blank here but i can see the results in log.

        SQLQuery2440_errorCode = 0
        SQLQuery2440_informationCode = 0
        SQLQuery2440_returnMessage = SQL query SQLQuery2440: Execution complete.
        SQLQuery2440_outputData =
        Activity completed: SQLQuery2440
        SQLQuery2440_RETURN_MSG = Success
        SQLQuery2440_RETURN_CODE = 0
        SQLQuery2440_errorCode = 0
        SQLQuery2440_informationCode = 0
        SQLQuery2440_returnMessage = SQL query SQLQuery2440: Execution complete.
        SQLQuery2440_outputData =
        SQLQuery2440_RECORD_COUNT = 66

        Basically i want to export the results in log , using msgbuilder or file access to a directory..when i used "SQLQuery2440_outputData = " in msgbuilder its getting errored out.

        Any way to export entire results without specifying individual variables in "SQLQuery2440_outputData = " ..?
        JimY
        Veteran Member
        Posts: 510
        Veteran Member
        4/21/2016 4:42 PM
          Did you check the box to Enable Sql result values outside the loop?
          Magus
          Basic Member
          Posts: 6
          Basic Member
          4/22/2016 7:31 AM
            Yes Jimy..But still no luck :crazy::cry:
            ---