The solution; use the $LASTCOUNT$ keyword. Since I'm running it immediately after refreshing the table, it should always pull the correct count.
Gary -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Wednesday, January 07, 2009 2:54 PM To: arslist@ARSLIST.ORG Subject: Re: Active Link works on dev; not on prod ** I thought setting an Integer field equal to a table puts the row number of the currently selected row into the Integer field Fred From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Opela, Gary L CTR USAF AFMC 72 CS/SCBAH Sent: Wednesday, January 07, 2009 2:50 PM To: arslist@ARSLIST.ORG Subject: Active Link works on dev; not on prod AR Server 6.3/ WUT 6.3/ Windows 2k3/ MSSQLServer So, I just developed a form and some active links on dev, then imported them into prod, and one of the ALs doesn't work. So, the active link does a set fields. It sets 'Ticket Count' = $tbl_Tickets$ On dev, this will set the Ticket Count integer field to the number of records in the tbl_Tickets table. This works fine in dev, but not in prod. Below are the logs from each table refresh: Dev: <WFLG> /* Wed Jan 07 2009 14:35:26 */ <WFLG> Workflow Trace Log -- ON <ACTL> /* Wed Jan 07 2009 14:35:28 */ <ACTL> Start active link processing -- Operation - On Menu Choice <ACTL> For Schema - HD: My Stats <ACTL> Linked to field - Table Properties: (536870936) <ACTL> On screen type - CREATE <ACTL> Checking HD: MS: Set Table Qual on Table Properties: Change (10) <ACTL> -> Passed qualification -- perform if actions <ACTL> 0: Set Fields <ACTL> Table Qual (536870935) = ( 'Submitter' = $\USER$) AND ( 'Create Date' >= "04/01/2008") <ACTL> Checking HD: MS: Refresh tbl_My Tickets (50) <ACTL> -> Passed qualification -- perform if actions <ACTL> 0: Set Characteristics <ACTL> For field -- Tickets (536870932) <ACTL> Refresh field <ACTL> 1: Set Fields <ACTL> Ticket Count: (536870937) = 21 <ACTL> /* Wed Jan 07 2009 14:35:28 */ <ACTL> Stop active link processing - On Menu Choice <WFLG> /* Wed Jan 07 2009 14:35:34 */ <WFLG> Workflow Trace Log -- OFF Prod: <WFLG> /* Wed Jan 07 2009 14:34:54 */ <WFLG> Workflow Trace Log -- ON <ACTL> /* Wed Jan 07 2009 14:35:02 */ <ACTL> Start active link processing -- Operation - On Menu Choice <ACTL> For Schema - HD: My Stats <ACTL> Linked to field - Table Properties: (536870936) <ACTL> On screen type - CREATE <ACTL> Checking HD: MS: Set Table Qual on Table Properties: Change (10) <ACTL> -> Passed qualification -- perform if actions <ACTL> 0: Set Fields <ACTL> Table Qual (536870935) = ( 'Submitter' = $\USER$) AND ( 'Create Date' >= "04/01/2008") <ACTL> Checking HD: MS: Refresh tbl_My Tickets (50) <ACTL> -> Passed qualification -- perform if actions <ACTL> 0: Set Characteristics <ACTL> For field -- Tickets (536870932) <ACTL> Refresh field <ACTL> 1: Set Fields <ACTL> Ticket Count: (536870937) = 0 <ACTL> /* Wed Jan 07 2009 14:35:03 */ <ACTL> Stop active link processing - On Menu Choice <WFLG> /* Wed Jan 07 2009 14:35:09 */ <WFLG> Workflow Trace Log - OFF Any help is greatly appreciated. Gary __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
