
Click above to get retro games delivered to your door ever month!
X-Hacker.org- The Guide To Clipper - <b>select</b>
[<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
SELECT
Syntax: SELECT <work area>/<alias>/(<expN>)
Purpose: To change the current work area.
Arguments: <work area> is a number between zero and 254 inclusive.
Zero designates the first available work area beginning with
work area one.
<alias> is the name of an existing work area if there is
a database file open in that area. The first 10 work areas
can be referred to with the letters A through J. Specifying
a non-existent alias produces a runtime error.
(<expN>) is a numeric expression that evaluates to a
number between zero and 254. The expression must be bounded
by opposing parentheses to be evaluated.
Usage: Clipper supports 254 work areas. SELECTing 0 selects the
first unused area. Within each work area, you can open a
database file and up to 15 index files. Each work area has
a number of attributes which include:
Table: List of Work Area Attributes
-----------------------------------------------------
Attribute Function
-----------------------------------------------------
Alias name ALIAS()
Work area number SELECT()
Database file ALIAS()
Index file(s) INDEXORD()/INDEXKEY()
Exclusivity FLOCK()/NETERR()
Filter condition DBFILTER()
Deleted filter
Locate condition
Relation(s) DBRELATION()/DBRSELECT()
Number of records LASTREC()/RECCOUNT()
Number of fields FCOUNT()
Record number RECNO()
Beginning-of-file flag BOF()
End-of-file flag EOF()
Found flag FOUND()
-----------------------------------------------------
Library: CLIPPER.LIB
----------------------------------- Example --------------------------------
last_area = SELECT()
SELECT 0
USE Newfile
*
<statements>...
*
SELECT (last_area)
See Also: USE SET INDEX ALIAS() SELECT()
Online resources provided by: http://www.X-Hacker.org --- NG 2 HTML conversion by Dave Pearson