Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: mike castillo
  Where is mike castillo?
 Joo Seng Road, Singapore
 Philippines
 mike castillo
 To: Vijayendran
  Where is Vijayendran?
 Chennai
 India
 Vijayendran
 Tags
Subject: RE: Incremental Search
Thread ID: 22523 Message ID: 22542 # Views: 45 # Ratings: 0
Version: Visual FoxPro 5 Category: General VFP Topics
Date: Tuesday, April 22, 2003 5:21:18 AM         
   


> Thnx I will try with combo, but any help for search through text box will be appreciable. Is there any examples available for such kind of a search.
>
> Regards
> Vijyendran
>
>
> > Combo box - dropdown listbox (if i'm not mistaken), have INCREMENTAL SEARCH capability.
> > How about substituting this instead of writing codes for the purpose.
> >
> > Rene-PCSO
> >
> > >
> > > i HAVE A TEXT BOX & A GRID. AS I KEYIN THE INDEXED VALUE I GET THE RESULT IN THE GRID. BUT I WANT THE SEARCH TO BE THIS WAY:
> > >
> > > AS I ENTER THE FIRST WORD , THE CURSOR SHOULD POINT TO THE STARTING LETTER OF THE VALUE IN SEQ SEARCH & AS I TYPE IN THE 2ND & 3RD WORDS, THE CURSOR SHOULD POINT TO THE RECORD CONTAINING THE NAME OF THE VALUE IN SEQ SEARCH. tHIS IS SOMETHING LIKE FINDING OF THE NAMES STATING & ENDING WITH PARTICULAR LETTERS IN VB. HOW CAN IT BE DONE IN VFP?ANYBODY TO HELP.
> > >
> > > REGARDS
> > > Vijayendran S
>
>
> Vijayendran S

on the textbox interactivechange event type this:
sele * from tablename where alltrim(This.value) = fieldname into cursor interactive order by fieldname group by fieldname

count to x
if x = 0 or EMPTY(This.Value)
	Thisform.list1.Visible = .F. && Add a listbox Object to the form
ELSE
	Thisform.list1.Visible = .T.
endif
Thisform.List1.rowsource = "interactive.orderto"
Thisform.List1.refresh



COMPLETE THREAD

SEQUENTIAL SEARCH!!!! Posted by Vijayendran @ 4/21/2003 2:28:28 PM
RE: SEQUENTIAL SEARCH!!!! Posted by vijayan @ 4/21/2003 2:47:47 PM
Incremental Search Posted by Rene Relucio @ 4/21/2003 4:01:22 PM
RE: Incremental Search Posted by Vijayendran @ 4/22/2003 5:10:51 AM
RE: Incremental Search Posted by mike castillo @ 4/22/2003 5:21:18 AM
RE: SEQUENTIAL SEARCH!!!! Posted by Cosmin Popescu @ 4/22/2003 6:56:11 AM
RE: SEQUENTIAL SEARCH!!!! Posted by Cosmin Popescu @ 4/22/2003 7:27:22 AM