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

Revision as of 16:15, 15 December 2009 (view source) Yvonnemilne (Talk | contribs) (→‎Deleting Records in a Recital Table) ← Older edit		Revision as of 16:16, 15 December 2009 (view source) Yvonnemilne (Talk | contribs) (→‎Obtain Information about a Recital Database Table) Newer edit →
Line 50:		Line 50:
	* DISPLAY/LIST INDEX		* DISPLAY/LIST INDEX
	* DISPLAY/LIST		* DISPLAY/LIST
		+
	* BOF()		* BOF()
	* EOF()		* EOF()
−	* FIELD()	+	* FIELD()
−	* FIELDNAME()	+	* FIELDNAME()
−	* FLDLIST()	+	* FLDLIST()
−	* INUSE()	+	* INUSE()
	* RECNO()		* RECNO()
−	* REFERENCES()	+	* REFERENCES()
−	* USED()	+	* USED()
	===Summary===		===Summary===

---

Revision as of 16:16, 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

• COPY STRUCTURE
• COPY
• 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

   * 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