Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Search the records
Message
De
27/12/2004 12:59:25
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Visual FoxPro Beta
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Database:
Visual FoxPro
Divers
Thread ID:
00972291
Message ID:
00972393
Vues:
15
>Thanks Tamar for your reply.
>but this is bit prolem
> SET FILTER TO " " + ALLTRIM(ThisForm.bname.Value) + " " $ UPPER(bname)
>it does not locate first word ,locate only from between.
>like this"my name is my name"
>first"my" ignore and scond my locate

You can add additional clauses to the filter to check for first and/or last word
SET FILTER TO (" " + UPPER(ALLTRIM(ThisForm.bname.Value)) + " " $ UPPER(bname)) ;
 OR (UPPER(LEFT(ALLTRIM(Thisform.bname.Value),LEN(bname)+1))) = (UPPER(bname)+" "));
 OR (UPPER(RIGHT(ALLTRIM(Thisform.bname.Value),LEN(bname)+1))) = (" "+UPPER(bname)));

You may have to verify the parens here, I'm not sure I got them exactly right
If bname = "is" This should find
"my name is my name"
"is this my name"
"how do you know what my name is"

and ignore
"my name isn't this"
"isn't this my name"
"my name isn't your name"
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform