Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Query with Containing
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00356777
Message ID:
00356850
Views:
19
>Thanks for everyones help, here is the code that seems to work pretty well so far, I put it in the keypress method of my textbox.
>*-------------------------------------------------------------------------*
>local lcString,nrow
>lcString='%'+allt(upper(thisform.text1.value))+'%'
>select dcode1,descriptio from c:\proclook ;
> where descriptio LIKE ?lcString ;
> into cursor xResults
>thisform.list1.clear()
>nrow=1
>if _tally > 0
> select xResults
> scan
> with thisform.list1
> .addlistitem(xjunk.dcode1,nrow,1)
> .addlistitem(xjunk.descriptio,nrow,2)
> endwith
> nrow=nrow+1
> * Limit the listing to 100 items for speed
> if nrow > 100
> exit
> endif
> endscan
>endif
>
>

I fugured it was feasible, but how is the response time on each keystroke? Is this going to work on a local table at the PC or will you be using any networked table?
Bret Hobbs

"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform