Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Search form slightly misbehaving
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00679248
Message ID:
00680053
Vues:
29
then, you got to some work here..

Try this...

lcFilterExpr = ""
FOR lnI = 1 TO LEN(lcSearchString)
lcFilterExpr = lcFilterExpr + "SUBSTR(Agency_Name," + STR(lnI) + ",1) >= '" + SUBSTR(lcSearchString,lnI,1) + "' AND "
NEXT
lcFilterExpr = LEFT(lcFilterExpr,LEN(lcFilterExpr) - 4)
SET FILTER TO &lcFilterExpr


>Jayesh,
>
>You're close, but the search result would be the names starting with L's and M's and N's and so on through letter Z.
>
>And if the search text contains "LE" the result starts with
>LEALMAN
>and skips LARGO and the rest after LEALMAN through the names beginning with the letter Z.
>
>Hope this defines the problem better.
- Jayesh
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform