I think it is because while inside the guide the table row is changing so on exiting the guide it is cleared
Fred From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor Sent: Tuesday, July 14, 2009 6:49 PM To: arslist@ARSLIST.ORG Subject: Re: Selecting a row in a table with an AL That worked! Any idea why it worked when done outside the guide but not in the guide? Thanks, Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Tuesday, July 14, 2009 3:14 PM To: arslist@ARSLIST.ORG Subject: Re: Selecting a row in a table with an AL I would suggest NOT setting the table to the correct row while inside the guide. Set a temp field with the correct row number and after the guide finishes set the table to the row. Fred From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor Sent: Tuesday, July 14, 2009 12:40 PM To: arslist@ARSLIST.ORG Subject: Selecting a row in a table with an AL Hi All, ARS 7.1 P6 I have a situation where I need to programmatically select a row in a table. Based on what I've read, I should be able to do it, and I've written the code that I think should do it, but it's not doing it. Basically, I have a display-only form with a table at the top that shows records the user can edit; the list is filtered based on the value of a couple selection fields. If they select a record, is populates the area below the table, where the user can make and save changes. Depending on the changes made, the contents of the table need to be updated to reflect the change in the record (or to display a newly created record). So, I've got a situation where, when I save the record, in some cases I refresh the table (clearing the selection, if there was one), and then I walk the table to see if the current record is present in it, and then select it, so it's highlighted. What I have is more or less like this: ALG - Save Record AL - Push Record to Regular Form AL - Refresh Table if Necessary AL - Reselect Record The Reselect Record AL simply loops over the table, incrementing a row counter along the way, and once it finds the matching row, it sets the row number to the table, something like this: AL - Reselect Record Set Row Counter to 1 Call Guide: Reselect Record ALG - Reselect Record AL - Select Current Record AL - Increment Row Counter AL - Select Current Row Run If: 'Request ID Col' = 'Request ID' Set Fields: Table = -$Row Count$ (Select the current row, but don't fire workflow) Exit Guide So, when I do active link logging, I can see it iterating over the table, finding the record and then setting the table to, say, -2, but the row in the table doesn't appear to get selected. Am I missing something? Thanks for your help, Lyle Taylor _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"