Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
AutoComplete
Message
 
 
To
27/01/2011 13:45:01
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01497563
Message ID:
01497610
Views:
164
>Autocompsource="NAME"
>Autocomptable="COUNTRY"
>Autocomplete = 1 && alphabetical order 0-none , 2- Most freq.used 3-MRU , 4-UDF order

>Dear Sir,
>
>I have following data
>
>
>CREATE TABLE COUNTRY (SNO N(2),NAME C(20))
>INSERT INTO COUNTRY VALUES (1,"AFGHANISTAN")
>INSERT INTO COUNTRY VALUES (2,"BANGLADESH")
>INSERT INTO COUNTRY VALUES (3,"CHINA")
>INSERT INTO COUNTRY VALUES (4,"DENMARK")
>INSERT INTO COUNTRY VALUES (5,"EGYPT")
>INSERT INTO COUNTRY VALUES (6,"FRANCE")
>INSERT INTO COUNTRY VALUES (7,"HUNGARY")
>INSERT INTO COUNTRY VALUES (8,"IRELAND")
>INSERT INTO COUNTRY VALUES (9,"JAPAN")
>INSERT INTO COUNTRY VALUES (10,"KOREA")
>
>
>
>I want to show COUNTRY.NAME in textbox as auto complete.
>
>What properties should I set?
>
>Autocompsource=?
>Autocomptable=?
>Autocomplete?
>
>Form and table is in attahment
>
>Thnaks
>
>http://www.foxite.com/uploads/94a11882-d98b-433e-a103-fae147f49e82.zip
Previous
Reply
Map
View

Click here to load this message in the networking platform