Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
vfp9 Set filter to ATC() help Re: Case sensitive.
Worked nice as well. Just updating the grid as advised with the Local... Thanks again guys. Saved me hours of mucking around.- ICCOOL
- Post #10
- Forum: Microsoft: FoxPro
-
vfp9 Set filter to ATC() help Re: Case sensitive.
Thank you. I shall take your advice. Very easy to change.- ICCOOL
- Post #8
- Forum: Microsoft: FoxPro
-
vfp9 Set filter to ATC() help Re: Case sensitive.
That worked perfectly. :) Thank you very much. I really appreciate it.- ICCOOL
- Post #5
- Forum: Microsoft: FoxPro
-
vfp9 Set filter to ATC() help Re: Case sensitive.
Thanks atlopes. I tried as below but the filter returns 0 results on the custview table either in upper or lower case. PUBLIC S4 S4=ALLTRIM(THIS.VALUE) && For example "SYDNEY" SELECT CUSTVIEW SET FILTER TO ATC(SUBURB, S4) != 0 GO TOP thisform.refresh- ICCOOL
- Post #3
- Forum: Microsoft: FoxPro
-
vfp9 Set filter to ATC() help Re: Case sensitive.
Hi guys. Have a small work program and need the filter to not be case sensitive. I'm not sure how to code it. I have tried but just get no returns or errors. Existing code works but is case sensitive. PUBLIC S4 S4=ALLTRIM(THIS.VALUE) SELECT CUSTVIEW SET FILTER TO S4 $SUBURB GO TOP...- ICCOOL
- Thread
- Replies: 9
- Forum: Microsoft: FoxPro
