Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

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

Status
Not open for further replies.

drosenkranz

Programmer
Sep 13, 2000
360
US
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"). 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.
 
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) They cling emotionally to code and fix development rather than choosing practices based on analytical assesments of what works best. - Steve McConnell
 
Thanks Weedz, appreciate the help.
The 2nd mouse gets the cheese.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top