Difference between revisions of "Using Navigational Data Access Commands in Recital"

From Recital Documentation Wiki
Jump to: navigation, search
(→‎Obtain Information about a Recital Database Table)
(→‎Obtain Information about a Recital Database Table)
Line 45: Line 45:
 
* DISPLAY/LIST INDEX
 
* DISPLAY/LIST INDEX
 
* DISPLAY/LIST
 
* DISPLAY/LIST
 +
 +
    * FIELD()
 +
    * FIELDNAME()
 +
    * FLDLIST()
 +
    * INUSE()
 +
    * REFERENCES()
 +
    * USED()
  
 
===Summary===
 
===Summary===

Revision as of 16:11, 15 December 2009

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
   * INDEX
   * REINDEX
   * 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
   * ZAP

Obtain Information about a Recital Database Table

  • DISPLAY/LIST STRUCTURE
  • DISPLAY/LIST INDEX
  • DISPLAY/LIST 
   * FIELD()
   * FIELDNAME()
   * FLDLIST()
   * INUSE()
   * REFERENCES()
   * USED()

Summary

Retrieved from "https://www.recitalsoftware.com/wiki/index.php?title=Using_Navigational_Data_Access_Commands_in_Recital&oldid=11696"