Forums
Lawson S3 Financials
SQL QUERY NODE outputData
Author
Messages
Magus
Basic Member
Posts: 6
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
4/19/2016 7:55 PM
Would you mind posting the SQL?
Magus
Basic Member
Posts: 6
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
4/21/2016 4:42 PM
Did you check the box to Enable Sql result values outside the loop?
Magus
Basic Member
Posts: 6
4/22/2016 7:31 AM
Yes Jimy..But still no luck :crazy::cry: