Understanding Datasets Index

Go Up to Developing Database Applications Index

Topics

• Understanding Datasets - Overview
• Using TDataSet Descendants
• Determining Dataset States
• Opening and Closing Datasets
• Navigating Datasets
  • Using the First and Last Methods
  • Using the Next and Prior Methods
  • Using the MoveBy Method
  • Using the Eof and Bof Properties
  • Marking and Returning to Records
• Searching Datasets
  • Using Locate
  • Using Lookup
• Displaying and Editing a Subset of Data Using Filters
  • Enabling and Disabling Filtering
  • Creating Filters
    • Setting the Filter Property
    • Writing an OnFilterRecord Event Handler
  • Setting Filter Options
  • Navigating Records in a Filtered Dataset
• Modifying Data
  • Editing Records
  • Adding New Records
  • Deleting Records
  • Posting Data
  • Canceling Changes
  • Modifying Entire Records
• Calculating Fields
• Types of Datasets
• Using Table Type Datasets
  • Sorting Records with Indexes
    • Obtaining Information About Indexes
    • Specifying an Index with IndexName
    • Creating an Index with IndexFieldNames
  • Using Indexes to Search for Records
    • Executing a Search with Goto Methods
    • Executing a Search with Find Methods
    • Specifying the Current Record After a Successful Search
    • Searching On Partial Keys
    • Repeating or Extending a Search
  • Limiting Records with Ranges
    • Understanding the Differences Between Ranges and Filters
    • Specifying Ranges
    • Modifying a Range
    • Applying or Canceling a Range
  • Creating Master-Detail Relationships
    • Making the Table a Detail of Another Dataset
    • Using Nested Detail Tables
  • Controlling Read-Write Access to Tables
  • Creating and Deleting Tables
  • Emptying Tables
  • Synchronizing Tables
• Using Query-type Datasets
  • Specifying the Query
  • Using Parameters in Queries
    • Supplying Parameters at Design Time
    • Supplying Parameters at Runtime
  • Establishing Master-detail Relationships Using Parameters
  • Preparing Queries
  • Executing Queries That Don't Return a Result Set
  • Using Unidirectional Result Sets
• Using Stored Procedure-type Datasets
  • Working with Stored Procedure Parameters
  • Preparing Stored Procedures
• Executing Stored Procedures That Don't Return a Result Set
  • Fetching Multiple Result Sets