Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Ryss Unger
  Where is Ryss Unger?
 Cape Town
 South Africa
 Ryss Unger
 To: Rommel Santillan Phil
  Where is Rommel Santillan Phil?
 Makati
 Philippines
 Rommel Santillan Phil
 Tags
Subject: RE: Grid ---- variable realationships... like()
Thread ID: 371 Message ID: 387 # Views: 4 # Ratings: 0
Version: Unknown Category: General VFP Topics
Date: Saturday, May 26, 2001 4:29:43 AM         
   


> > > >
> > > > When I issue a browse command like
> > > >
> > > > Browse field main,name,address,city for name='AAAAAA'
> > > >
> > > > How do I get put the same condition ie I want only names with 'AAAAA' to be displayed in the grid box
> > > >
> > > > Is it possible to do this
> > > >
> > > >
> > > >
> > > Take a look at the SET FILTER command in the help
> > >
> > > smith
> > Hi
> > I am not totally adverse to set filter but this is one application I would not use it.
> >
> > Grids are fantastic for their power and speed of presentation achieved via the relationship expression.
> >
> > so lets take and example.
> >
> > add a grid with alphabet " " then A - Z
> >
> > grid two names addresses etc
> >
> > click on A -----all name s with "A..... " are shown
> > click on B -----all name s with "B..... " are shown
> > do sequential search... type AB .....all name s with "AB..... " are shown
> > ... type ABC .....all name s with "ABC..... " are shown
> >
> >
> >
> > I am busy with this for FAQ. Anybody .. request code and I will post it on the forum as "TIP: Grid sequential search."
> >
> > Regards
> > Ryss
>
> In addition to this you can use SQL statement or sequential search using scan... endscan
> with a condition at(text2besearched, textwhere2search) > 0...
>
> it will improve the search process to locate the text not only on the first few letters but in the middle of the text.
>
> e.g. you want to find the records of employee with "AB" in their names...
> "GABBY" will be included...ü
> ü
>
> Rommel
Hi Rommel
Relatinal expressions are based in the index tag whcih is used to achieve the relational expression. And widcards can not be used in this application.


You would need to use something like:
SCAN FOR LIKE('*AB*', Emp_name)
Or locate for LIKE('*AB*', Emp_name)

Regards
Ryss

ENTIRE THREAD

Grid Posted by Manish Shah @ 5/25/2001 8:51:34 AM
RE: Grid Posted by chris smith @ 5/25/2001 11:53:14 AM
RE: Grid ---- variable realationships Posted by Ryss Unger @ 5/25/2001 2:21:54 PM
RE: Grid ---- variable realationships Posted by rommel santillan @ 5/25/2001 9:59:00 PM
RE: Grid ---- variable realationships... like() Posted by Ryss Unger @ 5/26/2001 4:29:43 AM
RE: Grid Posted by Paul Culbertson @ 5/25/2001 3:48:55 PM