Reply from dleroy on May 22 at 10:37 AM Thank you everyone for your help. I'll let you know what I end up doing.
| | | ---------------Original Message---------------
From: dleroy
Sent: Friday, May 18, 2012 2:04 PM
Subject: App Engine SQL Fetch
I have an application engine and in the peoplecode step, I have a SQL that selects about 300 fields. Then I use while loop with a fetch to fetch each row of data. Since there are so many fields, they won't fit on a line in the app engine so it produces an error. Here is a sample of the code.
Local SQL &sqlCURR_SUSPEND_QEUERY = GetSQL(SQL.ISIR_SELECT, &RC_Date1);
While &sqlCURR_SUSPEND_QUERY.Fetch(&ls_emplid, 300 more fields );
Since all the fields don't fit on a single line, I get a syntax error. "expecting ,. "
From experience, this is because all fields are not on 1 line in the app engine.
How do I fix this problem? Do I have to do several reads to the same data to get all the fields? Any other simple solution? Any help would be appreciated!
Thanks, |
| Reply to this email to post your response. __.____._ | In the Spotlight Become a blogger at Toolbox.com and share your expertise with the community. Start today.   _.____.__ |
No comments:
Post a Comment