• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Financial Management Lawson S3 Financials

SQL QUERY NODE outputData

 4 Replies
 0 Subscribed to this topic
 43 Subscribed to this forum
Sort:
Author
Messages
Magus
Basic Member Send Private Message
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 Send Private Message
Posts: 13
Basic Member
4/19/2016 7:55 PM
Would you mind posting the SQL?
Magus
Basic Member Send Private Message
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 Send Private Message
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 Send Private Message
Posts: 6
Basic Member
4/22/2016 7:31 AM
Yes Jimy..But still no luck :crazy::cry: