Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Search after each key press on a text_box object
Message
 
À
01/06/2005 11:18:18
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 7
OS:
Windows XP
Network:
Windows 2000 Server
Database:
Visual FoxPro
Divers
Thread ID:
01018973
Message ID:
01018979
Vues:
10
>I am looking for a way that will start searching the database for example
>(Phone Number) when a user start typing in a textbox object.
>
>
>Thank You In Advance
>
>
>Winfred Majors

Put in InterActiveChange Event of the TextBox:
SEEK this.Value IN YourTable ORDER TableOrder
....
the better way is to create a Method in the form Named i.e. SearchTable(evalueToSerach, cTableName, cOrder)

then In InterActiveChange Event of The TextBox:
thisform.SearchTable(this.Value, "TableorAliasName", "Order")

***in SearchTable method of the form:

LPARAMETERS evalueToSerach, cTableName, cOrder
SEEK evalueToSerach IN (cTableName) ORDER &cOrde
*** Do whatever you need
....
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform