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

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()