Okay, you led me to the answer.
On dev, the default for the field used in the EXTERNAL() call for the
table qualification would result in 1 ticket, and it was by default
highlighted. So, whenever I changed the menu, which would in turn change
the value in the field referenced in the EXTERNAL() call, it would
update the table, and would keep that same ticket highlighted. That
ticket happened to always be the last ticket in the table, so I was
getting the number of rows, essentially.
Now, on production, there were no records returned by the default
EXTERNAL() value. So, whenever I changed the field that the EXTERNAL()
referenced, and the table refreshed, no records were highlighted, and
that gave me a value of 0 for the table field.
I will do some table looping or something to get a count. I wish I could
use a ROWCOUNT('Table Field') function or something.
Gary
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[email protected]] On Behalf Of Grooms, Frederick W
Sent: Wednesday, January 07, 2009 2:54 PM
To: [email protected]
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:[email protected]] On Behalf Of Opela, Gary L CTR USAF AFMC 72
CS/SCBAH
Sent: Wednesday, January 07, 2009 2:50 PM
To: [email protected]
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"
