Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Search the records
Message
From
27/12/2004 12:59:25
 
 
General information
Forum:
Visual FoxPro
Category:
Visual FoxPro Beta
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00972291
Message ID:
00972393
Views:
14
>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"
Previous
Reply
Map
View

Click here to load this message in the networking platform