Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Search after each key press on a text_box object
Message
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:
01018993
Views:
11
>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


If this table has Index,
in InteractiveChange of textbox object

May be:
m.old_exact = SET('exact')
SET EXACT OFF
m.old_record = RECNO()
SEEK ALLTRIM(Ljust(UPPER(This.Value))) *** folow index expression
IF FOUND()
   ThisForm.Grid1.Refresh()
ELSE
   GOTO m.oldrecord
ENDIF
SET EXACT &m.old_exact
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst
Previous
Reply
Map
View

Click here to load this message in the networking platform