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 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 -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 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 > Remedy Manager > (914) 457-6209 > > Emerging Health IT > 3 Odell Plaza > Yonkers, New York 10701 > > > >>> [EMAIL PROTECTED] 05/30/08 8:44 AM >>> > 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' != $NULL$ > (this is the table name) > > I also tried: > > 'z2TF AssociationType' != $NULL$ > (this is a column name) > > Both of these do not work. > > However, if I remove this qualification my workflow works. > > Any ideas why I can't check to see if there are any rows in the table? > > THANKS! > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ > __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"