Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
Financial Management
Lawson S3 Financials
SQL QUERY NODE outputData
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
chaoticist
Past 24 Hours:
2
Prev. 24 Hours:
0
Overall:
5185
People Online:
Visitors:
312
Members:
0
Total:
312
Online Now:
New Topics
Top Forum Posters
Name
Points
Greg Moeller
4184
David Williams
3349
JonA
3288
Kat V
2984
Woozy
1973
Jimmy Chiu
1883
Kwane McNeal
1437
Ragu Raghavan
1348
Roger French
1311
mark.cook
1244
Forums
Unanswered
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Prev
Next
Forums
Lawson S3 Financials
SQL QUERY NODE outputData
Sort:
Oldest First
Most Recent First
You are not authorized to post a reply.
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:
You are not authorized to post a reply.