Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Setting filter on a table
Message
 
To
18/07/2002 10:54:42
Jerry Tovar
Dana Corporation Dana It
Maumee, Ohio, United States
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00679990
Message ID:
00680040
Views:
18
This message has been marked as the solution to the initial question of the thread.
Do you have any variables or field names for used aliases like "lc_product" ?
Anyway, it could be that as soon as you quit Interactivechange local variable lcfilter is no more recognized. Instead of
>SET FILTER TO mytable.myfield = lcfilter
try (assuming lcfilter has character type):
local lccom
lccom="SET FILTER TO mytable.myfield = '+lcfilter +"'"
&lccom



>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform