There are significant bugs with nested table loops. These are in all
releases of the user tool up to at least 7.0.0. I have not tested these
things beyond 7.0.0.
Do not use a qualification in the second table based upon a column in the
first (that is refreshed before calling the second). Instead, in the first
table loop, move all columns to DO fields and use those fields in the
qualifications. Similarly, in the second loop, make no references to the
columns of the first. Again, have the first move all columns to DO fields
and then have the second reference these fields.
So, in general
refresh table 1
call table loop 1
Loop1: move all columns to DO fields
refresh table 2 (using the DO fields in the qualifications)
call table loop2
Loop2: make no references to table 1's columns using
DO fields instead.
At least, when loop 2 completes (normally: do NOT exit!) it will go to the
next row in table 1.
So yes, it is possible...
Cheers
Ben_____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Chris Cook Sent: February 20, 2007 7:13 PM To: [email protected] Subject: Re: Walking Table Fields Hi Frank - I run nested AL Guide loops on a 6.0 server to build a file of command line arguments. Set Field 1 to $NULL$ <being loop table 1> Append 'table 1' value to 'Field 1' <begin loop table 2> Append 'table 2' value to 'Field 1' </end loop table 2> Append carriage return to 'Field 1' <end loop table 1> Walks both tables as expected. Christopher Cook Applications Analyst Payment Systems 625 Fourth Ave. S., Minneapolis, MN 55415-1665 Direct: 612-340-4342 Toll-free: 800-847-4836, ext. 34342 Email: <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED] This message contains confidential information intended only for the above addressees and may contain information that is proprietary or legally privileged. If you received this message in error, please notify us and delete the original message. You must obtain permission from Thrivent Financial to use its logo on all materials. Failure to do so could result in legal action. Frank Caruso <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" <[email protected]> 02/20/2007 12:13 PM Please respond to [email protected] To [email protected] cc Subject Walking Table Fields ** We are using server 6.03 with user tool 6 on AIX/Oracle Scenario: Button on a form runs an active link which calls a guide that Loops a table The first guide has one active link which calls another guide that Loops a table. Problem: The second active link successfully walks the second table but the first table never moves beyond the first row. Is what I am trying to do possible? __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
<<attachment: ATT00313.jpg>>
