Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Setting filter on a table
Message
 
À
18/07/2002 10:54:42
Jerry Tovar
Dana Corporation Dana It
Maumee, Ohio, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Divers
Thread ID:
00679990
Message ID:
00680040
Vues:
19
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform