Working with Records
When you have designed and created the structure for a table, you can store data in the table by adding new records. Later, you will change and delete existing records. Each of these tasks can be accomplished either through the interface or by using commands. This section focuses primarily on working with records programmatically.
In This Section
- Adding Records
Provides instructions on how to add records to a table, add a new blank record, append records from another file, display records for editing, and store a null value in a field. - Deleting Records
Provides instructions on how to mark a record for deletion, unmark a record marked for deletion, and remove records marked for deletion from disk. - Index Creation for Tables
Offers background on the capabilities of index tables and their importance in application development.
Related Sections
- Working with Data
Find out how to create effective applications with indexes, tables, and databases based on your data requirements. - Designing Databases
Take advantage of relational database technology in Microsoft Visual FoxPro with well-planned databases. - Developing Databases
Use databases in Microsoft Visual FoxPro to establish relationships between tables, enforce referential integrity, and manage local and remote data. - Working with Tables
Make sure your tables have the structure that your application requires. Data type and index choices are essential to the success of your application. - Importing and Exporting Data
Information is copied between Microsoft Visual FoxPro and other applications by importing to and exporting from Visual FoxPro. - Working with Multiple Tables
Explains how to open a Data Session window, open a table in a work area, and close a table in a work area.