Create a temporary field and keep populating that field with the value each time the loop is executed, separated with a comma sign or a cap ^ or any other unique identifier. Once you get a string of values, re-engineer them using another Loop and use them to call your DDE application to populate the values on Excel. Hope this helps.
Regards,
Roney Samuel Varghese
On 9/22/06, Sullivan, Neil G CTR USAF AFRL/SNOX <[EMAIL PROTECTED]
> wrote:
**Roney,The problem I'm having now is that it run the loop but set the value of each row in one field instead of each row in a different field. How do I tell it to set a different field for each row?Neil
** Dear Neil,
From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Roney Samuel
Sent: Friday, September 22, 2006 11:30 AM
To: [email protected]
Subject: Re: Table Looping
Its actually quite simple...You run a AL guide on the selected rows. The AL in the guide should run the set field action to set the column values to the hidden fields. the only trick is that the AL guide should run on selected rows and the table should only allow single selection. Hope this helps.
Regards,
Roney Samuel Varghese
On 9/22/06, Sullivan, Neil G CTR USAF AFRL/SNOX <[EMAIL PROTECTED] > wrote:**__20060125_______________________This posting was submitted with HTML in it___What should be such an easy process seems to be kicking my backside. Here's my problem:
I have a table with several records. I have several hidden fields to capture the request id from each row in the table. I need to run a table loop to set these hidden fields for each row so I can then do a DDE push to an Excel template.
I have been able to make it work for the first row, but how do I make it select each row and set the fields?
I'm running Windows 2003 server, Oracle 9i, and ARS 6.0.1, patch 1420.
Any help is appreciated.
Neil "Sully" Sullivan
Remedy Developer/Administrator
AFRL/SNOX
Wright Patterson AFB, OH 45433
937-904-9788
__20060125_______________________This posting was submitted with HTML in it_____20060125_______________________This posting was submitted with HTML in it___
__20060125_______________________This posting was submitted with HTML in it___
