Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL filters
Message
De
14/12/2005 17:49:21
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
SQL filters
Divers
Thread ID:
01078076
Message ID:
01078076
Vues:
59
If I set a filter as in:

set filter to loc_id = 'A-21'
browse

the result will correctly show one record.
But if I issue:

set exact on
set filter to loc_id = 'A-21'
filterstr = filter()
select * where &filterstr

the result returns A-21, A-219, A-216, A-213 etc. Which is not what we want.

This can be overcome by setting the initial filter as:
set filter to loc_id == 'A-21'

but this construct is difficult in my situation. Is there another solution?

Thanks
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform