Click above to get retro games delivered to your door ever month!

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)