Difference between revisions of "Using Navigational Data Access Commands in Recital"
From Recital Documentation Wiki
Barrymavin (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| Line 3: | Line 3: | ||
===Creating a Recital Database=== | ===Creating a Recital Database=== | ||
===Opening a Recital Database=== | ===Opening a Recital Database=== | ||
| + | |||
===Creating a Recital Table=== | ===Creating a Recital Table=== | ||
| + | * CREATE | ||
| + | * COPY STRUCTURE | ||
| + | * COPY | ||
| + | * COPY STRUCTURE EXTENDED | ||
| + | * SQL CREATE TABLE | ||
===Opening a Recital Table=== | ===Opening a Recital Table=== | ||
| + | * USE | ||
| + | ===Navigating a Recital Table=== | ||
| + | * GOTO | ||
| + | * INDEX | ||
| + | * REINDEX | ||
| + | * SEEK | ||
| + | * SKIP | ||
===Inserting Data into a Recital Table=== | ===Inserting Data into a Recital Table=== | ||
| − | ===Selecting Records from 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 === | ===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=== | ===Obtain Information about a Recital Database Table=== | ||
| + | * DISPLAY/LIST STRUCTURE | ||
| + | * DISPLAY/LIST INDEX | ||
| + | |||
===Summary=== | ===Summary=== | ||
Revision as of 16:02, 15 December 2009
Contents
- 1 Using Navigational Data Access Commands in Recital
- 1.1 Why use Navigational Data Access Commands
- 1.2 Creating a Recital Database
- 1.3 Opening a Recital Database
- 1.4 Creating a Recital Table
- 1.5 Opening a Recital Table
- 1.6 Navigating a Recital Table
- 1.7 Inserting Data into a Recital Table
- 1.8 Selecting Records from a Recital Table
- 1.9 Adding Records to a Recital Table
- 1.10 Deleting Records in a Recital Table
- 1.11 Obtain Information about a Recital Database Table
- 1.12 Summary
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
* 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
