Re: Question: Active Link - Checking Table - ITSM 7

2008-06-01 Thread mentor
: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of T. Dee Sent: Friday, May 30, 2008 8:54 AM To: [EMAIL PROTECTED] Subject: Re: Question: Active Link - Checking Table - ITSM 7 THANKS I'll give these suggestions a try. Ty On 5/30/08

Question: Active Link - Checking Table - ITSM 7

2008-05-30 Thread T. Dee
I'm trying to check to see if a table has any rows in it, but i'm not having much luck. I have tried to check for the table NOT being NULL and I have check for a column NOT being NULL, both do not work. I'm looking to see if the Relationship table is NOT NULL - so I tried: 'z2TH Associations'

Re: Question: Active Link - Checking Table - ITSM 7

2008-05-30 Thread Benedetto Cantatore
Off the top of my head, I think that you do a direct sql that would return the same results that the table would and then do a set field command using the value of lastcount. I think that would give you a number and you can build workflow to check if the value is greater than 0. Ben Cantatore

Re: Question: Active Link - Checking Table - ITSM 7

2008-05-30 Thread Carey Matthew Black
T. Dee, Is the 'z2TH Associations' field a required field? ( Or could it happen to be NULL for the currently selected row in the table?) In a Run If a column name value will only evaluate the currently selected record in the table field and not the array of values that are in all rows in the

Re: Question: Active Link - Checking Table - ITSM 7

2008-05-30 Thread Steven Iocco
What Ben mentioned is a good option. You could also run a guide looping on the 'z2TH Associations' table to give you a $LASTCOUNT$ number and as mentioned below, build your workflow on that result. Steve Date: Fri, 30 May 2008 09:13:32 -0400From: [EMAIL PROTECTED]: Re: Question: Active

Re: Question: Active Link - Checking Table - ITSM 7

2008-05-30 Thread T. Dee
on that result. Steve Date: Fri, 30 May 2008 09:13:32 -0400 From: [EMAIL PROTECTED] Subject: Re: Question: Active Link - Checking Table - ITSM 7 To: arslist@ARSLIST.ORG ** Off the top of my head, I think that you do a direct sql that would return the same

Re: Question: Active Link - Checking Table - ITSM 7

2008-05-30 Thread Gary Opela (Corporate)
:2000 Certified, CMMI(r) Level 3 Rated Company -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of T. Dee Sent: Friday, May 30, 2008 8:54 AM To: arslist@ARSLIST.ORG Subject: Re: Question: Active Link - Checking Table - ITSM 7

Re: Question: Active Link - Checking Table - ITSM 7

2008-05-30 Thread T. Dee
, May 30, 2008 8:54 AM To: arslist@ARSLIST.ORG Subject: Re: Question: Active Link - Checking Table - ITSM 7 THANKS I'll give these suggestions a try. Ty On 5/30/08, Steven Iocco [EMAIL PROTECTED] wrote: ** What Ben mentioned is a good option. You could also run a guide looping

Re: Question: Active Link - Checking Table - ITSM 7

2008-05-30 Thread jham36
below, build your workflow on that result. Steve Date: Fri, 30 May 2008 09:13:32 -0400 From: [EMAIL PROTECTED] Subject: Re: Question: Active Link - Checking Table - ITSM 7 To: [EMAIL PROTECTED] ** Off the top of my head, I think that you do