Freigeben über


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