Drew, While all these methods would work, use a little caution about refreshing the table field if not needed to be refreshed if the table against which that table field is built is a large table. You do not really want to get the results back if they are not needed..
In that case I would use a direct SQL with a select count(*) where whatever the criteria is on the table field qualification and set that to a field. The cost of this would be less than getting results back and then doing a count over the result set on the table field.. Cheers Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]]on Behalf Of Lyle Taylor Sent: Thursday, February 04, 2010 5:36 PM To: [email protected] Subject: Re: Entries in Table Field on Open or Display? ** Note that you may need to make sure the table field has been refreshed before checking how many rows are in it. Otherwise, it may come back as zero. Lyle From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Ray Palla Sent: Thursday, February 04, 2010 3:30 PM To: [email protected] Subject: Re: Entries in Table Field on Open or Display? ** Drew; I think if your AL has a qualification of >0 on the table field ID itself, you will get a value if the table has an entry. R ---------------------------------------------------------------------------- -- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Drew Shuller Sent: Thursday, February 04, 2010 3:52 PM To: [email protected] Subject: Entries in Table Field on Open or Display? ** Good afternoon listers. Is there a way to tell if a table field contains any entries when a record is Displayed or Opened, so that I can fire an AL? -- Drew Sent from Miami, FL, United States That's a laugh! I'm in Comayagua. _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
