Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Jun Tangunan
  Where is Jun Tangunan?
 Cabanatuan
 Philippines
 Jun Tangunan
 To: Saifuddin Hussain
  Where is Saifuddin Hussain?
 Dubai
 United Arab Emirates
 Saifuddin Hussain
 Tags
Subject: RE: Filter Record
Thread ID: 373334 Message ID: 373420 # Views: 34 # Ratings: 1
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Friday, March 22, 2013 6:12:41 AM         
   


> >
> > You need to evaluate the variable:
> >
> >
cDisplayValue = Alltrim(Upper(This.Value))
> >  Select pcode As pcode,Lpo as Lpo,sono as Sono,sodate as sodate,location as Location From somain ;
> >      WHERE Upper(CustLoca.pcode) = Upper(m.cDisplayValue) and LPO LIKE "%" + m.cDisplayValue + "%" INTO Cursor TmpCust
> >  

> >
> >
> > Tamar
>
> Thanks for your valuable reply! When I type 8 in LPO field it is showing but when to filter more like 833 it disappear as shown below:
>
> Saifuddin
>
>


Study sample from here: http://sandstorm36.blogspot.com/2012/06/grid-tricks3-clearer-search-results.html

Also, when the source is just from a single table, better use NOFILTER clause because without that you are just creating a filtered result.


http://sandstorm36.blogspot.com
http://weblogs.foxite.com/sandstorm36

ENTIRE THREAD

Filter Record Posted by Saifuddin Hussain @ 3/21/2013 11:16:10 AM
RE: Filter Record Posted by llyrad atsituab @ 3/21/2013 1:07:14 PM
RE: Filter Record Posted by Saifuddin Hussain @ 3/21/2013 9:05:35 PM
RE: Filter Record Posted by Tamar Granor @ 3/21/2013 9:27:39 PM
RE: Filter Record Posted by Saifuddin Hussain @ 3/21/2013 9:51:30 PM
RE: Filter Record Posted by Jun Tangunan @ 3/22/2013 6:12:41 AM
RE: Filter Record Posted by Saifuddin Hussain @ 3/22/2013 11:15:28 AM
RE: Filter Record Posted by Saifuddin Hussain @ 3/22/2013 1:18:29 PM