Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Setting filter on a table
Message
From
18/07/2002 10:54:42
Jerry Tovar
Dana Corporation Dana It
Maumee, Ohio, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
Setting filter on a table
Miscellaneous
Thread ID:
00679990
Message ID:
00679990
Views:
46
Using VFP7.

I have a table in my form that I display in a grid. I want to be able to set a filter on the table when a user selects a value from a drop down.

In my drop down Interactivechange I do this:

***
SELECT mytable
LOCAL lcfilter
lcfilter = THISFORM.combo.value
SET FILTER TO mytable.myfield = lcfilter
***

When I do this, I keep getting an error "Variable lc_product is not found".

How do you set a filter in a form?

Thanks,

Jerryt
Next
Reply
Map
View

Click here to load this message in the networking platform