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

From Recital Documentation Wiki
Jump to: navigation, search
(Inserting Data into a Recital Table)
(Obtain Information about a Recital Database Table)
Line 64: Line 64:
 
* ZAP
 
* ZAP
  
===Obtain Information about a Recital Database Table===
+
===Obtain Information about a Recital Table===
 
* DISPLAY/LIST STRUCTURE
 
* DISPLAY/LIST STRUCTURE
 
* DISPLAY/LIST INDEX
 
* DISPLAY/LIST INDEX

Revision as of 02:16, 16 December 2009

Using Navigational Data Access Commands in Recital

Why use Navigational Data Access Commands

Creating a Recital Database

  • CREATE DATABASE

Opening a Recital Database

  • OPEN DATABASE

Creating a Recital Table

  • CREATE
  • CREATE FROM
  • COPY STRUCTURE
  • COPY TO
  • COPY STRUCTURE EXTENDED
  • SQL CREATE TABLE

Opening a Recital Table

  • SELECT
  • SELECT()
  • USE

Navigating a Recital Table

  • GOTO
  • GOTO()
  • INDEX
  • REINDEX
  • SEEK
  • SEEK()
  • SKIP

Inserting Data into a Recital Table

  • APPEND FROM
  • BLANK
  • GATHER
  • GENERATE
  • REPLACE

Updating Data in a Recital Table

  • GATHER
  • 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 Table

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