Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Query with Containing
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00356777
Message ID:
00356850
Vues:
28
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform