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.
• 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.

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.
• Creating 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.