No double quotes around the entire qual; use the field db name and not the field label in the qual. Looks like you are using the field label, probably because you created the qual using the advanced search bar.
Axton Grams On 10/4/07, Shellman, David <[EMAIL PROTECTED]> wrote: > > > > Andy, > > A qualification that works in the Advanced Search bar doesn't work with > External. > > If I remember correctly the whole statement must be enclosed in double > quotes. > > I don't have my laptop connected up at the moment so I can't give you an > example. > > Dave > -------------------------- > [EMAIL PROTECTED] (Wireless) > > > ----- Original Message ----- > From: Action Request System discussion list(ARSList) <arslist@ARSLIST.ORG> > To: arslist@ARSLIST.ORG <arslist@ARSLIST.ORG> > Sent: Thu Oct 04 18:06:31 2007 > Subject: EXTERNAL command problems > > ** > > I am trying to have a table populate based on a drop-down field selection. > > > > I have created a temp field (zTmpHiddenTableQual) to hold the qualification > statement. > > This field gets set by an active link that fires when making a selection > from a drop-down menu. > > The active link is firing and the qualification statement is getting set > into the temp field. > > The second action on the active link does a change field that refreshes the > table. > > > > I have the table properties qualification set like this: EXTERNAL( > $zTmpHiddenTableQual$) > > > > The value in the zTmpHiddenTableQual field does contain a valid > qualification statement, but the table is blank. > > > > The value in the zTmpHiddenTableQual is : '*Assigned Group' = "SIA_Config", > which if pasted in the advanced qualification bar for the referenced form > returns the values as expected. > > > > I thought I was setting up the way the documentation descibed, but I > obviously an missing somthing. > > > > ARS 7.0.01 P002 > > Windows 2003 > > MS SQL > > > > Andy L. Mayfield > Sr. System Operation Specialist > Alabama Power Company > Office: 205-226-1805 > Cell: 288-9140 > SoLinc: 19140 > > > > __20060125_______________________This posting was > submitted with HTML in it___ > > > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
