Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Search after each key press on a text_box object
Message
 
To
01/06/2005 11:18:18
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 7
OS:
Windows XP
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01018973
Message ID:
01018979
Views:
9
>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.
Previous
Reply
Map
View

Click here to load this message in the networking platform