I would also use Display vs. Window Loaded. Display only fires when an existing record loads. Window Loaded fires after the default values are loaded on a form (which could realistically be the best choice only in Search or New mode), but before the data is loaded. Using Display also removes the need for the $OPERATION$ keyword.
Rick On Fri, May 30, 2008 at 9:46 AM, Thad K Esser <[EMAIL PROTECTED]> wrote: > ** > Make sure you take off the "Window Open" condition, otherwise your table > will refresh twice every time the form opens (you can see it in the logs) > > *Thad Esser* > Remedy Developer > "*Argue for your limitations, and sure enough, they're yours."*-- Richard > Bach > > > *"Morrison, David A." <[EMAIL PROTECTED]>* > Sent by: "Action Request System discussion list(ARSList)" < > [email protected]> > > 05/30/2008 09:26 AM > Please respond to > [email protected] > > To > [email protected] cc > Subject > SOLVED: Tables not refreshing "On Open" > > > > > ** > It says "click to refresh. I added the condition "Window Loaded" and it > is now refreshing when the form opens. > Thanks to all who helped! Have a great day!! > > David Morrison East Tennessee State Univ > > *From:* Action Request System discussion list(ARSList) [mailto: > [EMAIL PROTECTED] *On Behalf Of *Hall Chad - chahal* > Sent:* Friday, May 30, 2008 12:19 PM* > To:* [EMAIL PROTECTED] > Subject:* Re: Tables not refreshing "On Open" > > ** > When you say the table doesn't refresh, does it still display "Click to > refresh" within the table field? Or is it just an empty table? If it doesn't > have that wording and its just empty, then it refreshed but didn't find any > matches. In which case you should check your qualification. Since you say it > only fires on Window Open, that is before any values have been loaded into > any fields. So if the qualification references any other fields on the > current form then its search qualification will probably find no matches. > You would need to change it to Window Loaded (or maybe just Display) if that > is the case. > > *Chad Hall* > (501) 342-2650 > ------------------------------ > > *From:* Action Request System discussion list(ARSList) [mailto: > [EMAIL PROTECTED] *On Behalf Of *Morrison, David A.* > Sent:* Friday, May 30, 2008 11:13 AM* > To:* [EMAIL PROTECTED] > Subject:* Re: Tables not refreshing "On Open" > > Only condition is Window Open. Thanks for replying. > > *From:* Action Request System discussion list(ARSList) [mailto: > [EMAIL PROTECTED] *On Behalf Of *Rick Cook* > Sent:* Friday, May 30, 2008 12:04 PM* > To:* [EMAIL PROTECTED] > Subject:* Re: Tables not refreshing "On Open" > > ** David, what are the firing conditions on this Active Link? > > Rick > On Fri, May 30, 2008 at 8:56 AM, Morrison, David A. <* > [EMAIL PROTECTED] <[EMAIL PROTECTED]>> wrote: > Good day everybody, > > Strange problem that is driving me nuts. I have an Active Link that has > as one of its actions a Change Field on a table with the option being > "Refresh Table". The worklog says the qualification passes and lists > the action, but the table does not refresh when the form opens. Only > one view and all permissions have been checked. Any ideas would be > greatly appreciated. > > AR 7.1 patch 2 > Windows Server 2003 > SQL 2005 > > > David Morrison > East Tennessee State University > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at > *www.arslist.org*<http://www.arslist.org/> > Platinum Sponsor: *www.rmsportal.com* <http://www.rmsportal.com/> ARSlist: > "Where the Answers Are" > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ > ************************************************************************* > The information contained in this communication is confidential, is > intended only for the use of the recipient named above, and may be > legally privileged. > > If the reader of this message is not the intended recipient, you are > hereby notified that any dissemination, distribution or copying of this > communication is strictly prohibited. > > If you have received this communication in error, please resend this > communication to the sender and delete the original message or any copy > of it from your computer system. > > Thank you. > ************************************************************************* > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers > Are" html___ > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ > > ***IMPORTANT NOTICE: This communication, including any attachment, contains > information that may be confidential or privileged, and is intended solely > for the entity or individual to whom it is addressed. If you are not the > intended recipient, you should delete this message and are hereby notified > that any disclosure, copying, or distribution of this message is strictly > prohibited. Nothing in this email, including any attachment, is intended to > be a legally binding signature.*** > __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"

