Hi Norbert,
You are right. Use the database name or field id.
The extra """" is used in Set-Fields when you "construct" your qualification.
The resulting data in the zTmpHiddenTableQual itself should be without any
extra stuff, except in the case of keywords...
'536870913' = "SIA_Config"
To do the above in a Set-Fields, I would write the following:
"'536870913' = ""SIA_Config"""
Or if I have a value field called 'SelectedGroup':
"'536870913' = """ + $SelectedGroup$ + """"
Best Regards - Misi, RRR AB, http://www.rrr.se
Products from RRR Scandinavia:
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
* RRR|Translator - Manage and automate your language translations.
Find these products, and many free tools and utilities, at http://rrr.se.
> Hi Andy,
>
> I think you have to use the database name and not the label in EXTERNAL
> qualifications.
>
> Kind regards
> Norbert
>
>
> Mayfield, Andy L. schrieb:
>> **
>>
>> 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"
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
