Reply from Shelby on May 23 at 10:25 AM You can read the select into an array of any and then reference each field based on the field number.
&A = CreateArrayAny("");
&SQL = CreateSQL("SELECT EMPLID, EMPL_RCD FROM PS_JOB WHERE ROWNUM < 200");
While &SQL.fetch(&A)
MessageBox(0, "", 0, 0, &A [1] | " " | &A [2]);
End-While;
| | | ---------------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. __.____._ |   _.____.__ |
No comments:
Post a Comment