How To Make A Local View Evaluate A Variable In Its Filter Condition 1

[drosenkranz]

Hello There,

I'm trying to specify a filter condition (in a local view) that requires a field Client_ID to be equal to a memory variable gn_Client_ID. When I try to specify the gn_Client_ID variable as the conditional value used in the Filter Tab of my local view, it thinks that gn_ClientID is actually a character expression ( "gn_Client_ID&quot. It frames it in quotes instead of evaluating the memory variable.

How can I get the local view's filter condition to evaluate the "contents" of the gn_Client_ID memory variable as the condition (filter) for inclusion in the local view instead of using the memory variable's name "gn_ClientID" as the value in the comparison?

Thanks
The 2nd mouse gets the cheese.

 

[weedz]

If you are talking about a view parameter try placing a ? (questionmark) before the view parameter.

FILTER condition:

mytable.fieldname == ?vp_param

HTH,
Weedz (Wietze Veld)

http://www.crowncap.demon.nl

They cling emotionally to code and fix development rather than choosing practices based on analytical assesments of what works best. - Steve McConnell

 

[drosenkranz]

Thanks Weedz, appreciate the help.
The 2nd mouse gets the cheese.