0
Dear Sir, I would like to use Database field lookup in FoxPro 2.0 (MS-DOS).. Structure for database: C:\FOX\COUNTRY.DBF Number of data records: 140 Date of last update : 05/05/2004 Field Field Name Type Width Dec Index 1 COUNTRY Character 20 2 ID Numeric 2 ** Total ** 23 Data:- 1. United States of America 2. Uzbekistan 3. Australia 4. United Arab Emirates I would like to get listing of the countries from COUNTRY.DBF with @ SAY... GET. If I type "Au" (before press ) it should locate Australia, or "United S" it should bring cursor to United States of America (just like a look-up combo box in MS-Access etc). If I press the current country name to store in the memory variable. If I type anything else which is not in the COUNTRY.DBF, it should store in the memory variable. TEST.PRG cname=space(30) @05,03 SAY "Country : "get cname read Please help me out with a sample code, for the above. Thanx n regds.. Ashraf I also post it at: http://database.webmasterfund.com/devarchived/77/22077-database-field-lookup-in-foxpro-2-0.html Post here or post at database.webmasterfund.com, don't email. If you feel you have to mail, revert my....
Wiki User
∙ 15y ago
Add your answer:
Earn +20 pts
Advantages and disadvantages of foxpro?
discuss database and field functions
What is Lookup Wizard?
The lookup wizard allows you to create a field that sources its data from a list of values of a field in another table or query.
What field allows the user to select from a list of values?
Lookup field
Is 'A database uses characteristics such as field size and data type to define each field' false?
No it is not false. Database fields do have field sizes and data types.No it is not false. Database fields do have field sizes and data types.No it is not false. Database fields do have field sizes and data types.No it is not false. Database fields do have field sizes and data types.No it is not false. Database fields do have field sizes and data types.No it is not false. Database fields do have field sizes and data types.No it is not false. Database fields do have field sizes and data types.No it is not false. Database fields do have field sizes and data types.No it is not false. Database fields do have field sizes and data types.No it is not false. Database fields do have field sizes and data types.No it is not false. Database fields do have field sizes and data types.
What field in a database is identified by a field?
A field in a database is often identified by a unique field or column name. This field name serves as the identifier for that particular data attribute within the database table. Assigning distinct and meaningful field names helps organize and reference the data effectively within the database system.
What is the name of the field that is in either ascending or descending order and will be searched when a table-lookup is performed?
Index field.
What are field property in database?
is where the properties in the field is unique
What is a key field in database?
i key field is a field with with a key in the middle :)
Why choosing the correct field in database is important?
Choosing the correct field in database is very important. It is because the correct field can give you the correct value.
What characteristics in a database fields may have such as data type field name field size and field format?
What characteristics could a database field have, such as data type, field name, field size and field format?
What sequence represents the hierarchy of terms from smallest to largest from field record database and table?
field, record, table, database
What is a database field name?
A database field name is a unique identifier for a particular piece of data within a database table. It helps to organize and distinguish different types of information stored in the database. Each field name typically corresponds to a specific attribute or characteristic of the data being stored.
