Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Search the word
Message
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01025098
Message ID:
01025111
Views:
14
 <<SET FILTER TO " " + ALLTRIM(ThisForm.file.Value) + " " $ upper(fm);
<<           OR " " + ALLTRIM(ThisForm.file.Value) + " " $ upper(sm)
>Boris which words have problem, with your codes nothing found, which word have not problem alos found.
>thanks

Some mix between my and Hilmar's answer:
m.transchar = [,.:'"/\`~%#@$^&*()-+=",]+"[]"
SET FILTER TO " " + ALLTRIM(ThisForm.file.Value) + " " $ UPPER(STRTRAN(fm,m.transchar,[]));
           OR " " + ALLTRIM(ThisForm.file.Value) + " " $ upper(STRTRAN(sm,m.transchar,[]))
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform