Difference between revisions of "Using Navigational Data Access Commands in Recital"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) (→Navigating a Recital Table) |
Yvonnemilne (Talk | contribs) (→Obtain Information about a Recital Database Table) |
||
| Line 48: | Line 48: | ||
* DISPLAY/LIST INDEX | * DISPLAY/LIST INDEX | ||
* DISPLAY/LIST | * DISPLAY/LIST | ||
| − | + | * BOF() | |
| + | * EOF() | ||
* FIELD() | * FIELD() | ||
* FIELDNAME() | * FIELDNAME() | ||
* FLDLIST() | * FLDLIST() | ||
* INUSE() | * INUSE() | ||
| + | * RECNO() | ||
* REFERENCES() | * REFERENCES() | ||
* USED() | * USED() | ||
===Summary=== | ===Summary=== | ||
Revision as of 16:12, 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 * GOTO() * INDEX * REINDEX * SEEK * 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
- BOF()
- EOF()
* FIELD() * FIELDNAME() * FLDLIST() * INUSE()
- RECNO()
* REFERENCES() * USED()
