Using Navigational Data Access Commands in Recital

From Recital Documentation Wiki
Revision as of 16:16, 15 December 2009 by Yvonnemilne (Talk | contribs)

Jump to: navigation, search

Using Navigational Data Access Commands in Recital

Why use Navigational Data Access Commands

Creating a Recital Database

Opening a Recital Database

Creating a Recital Table

   * CREATE
  • COPY STRUCTURE
  • COPY
  • COPY STRUCTURE EXTENDED
  • SQL CREATE TABLE

Opening a Recital Table

   * USE

Navigating a Recital Table

   * GOTO
   * GOTO()
   * INDEX
   * REINDEX
   * SEEK
   * SEEK()
   * SKIP

Inserting Data into a Recital Table

   * BLANK
   * GATHER
   * GENERATE
   * REPLACE

Selecting Records from a Recital Table

   * AVERAGE
   * COUNT
  • DISPLAY
  • LIST
   * SCAN
   * SCATTER
   * SUM
   * TOTAL

Adding Records to a Recital Table

  • APPEND
  • APPEND BLANK
  • INSERT

Deleting Records in a Recital Table

  • DELETE
  • PACK
  • RECALL
  • SET DELETED
  • ZAP

Obtain Information about a Recital Database Table

  • DISPLAY/LIST STRUCTURE
  • DISPLAY/LIST INDEX
  • DISPLAY/LIST
  • BOF()
  • EOF()
  • FIELD()
  • FIELDNAME()
  • FLDLIST()
  • INUSE()
  • RECNO()
  • REFERENCES()
  • USED()

Summary