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

From Recital Documentation Wiki
Jump to: navigation, search
(→‎Creating a Recital Table)
(→‎Navigating a Recital Table)
Line 15: Line 15:
 
     * USE
 
     * USE
 
===Navigating a Recital Table===
 
===Navigating a Recital Table===
−
    * GOTO
+
* GOTO
−
    * GOTO()
+
* GOTO()
−
    * INDEX
+
* INDEX
−
    * REINDEX
+
* REINDEX
−
    * SEEK
+
* SEEK
−
    * SEEK()
+
* SEEK()
−
    * SKIP
+
* SKIP
  
 
===Inserting Data into a Recital Table===
 
===Inserting Data into a Recital Table===

Revision as of 16:18, 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
  • CREATE FROM
  • COPY STRUCTURE
  • COPY TO
  • 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

  • APPEND FROM
  • 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

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