[<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
 SELECT()
 Determine the work area number of a specified alias
------------------------------------------------------------------------------
 Syntax

     SELECT([<cAlias>]) --> nWorkArea

 Arguments

     <cAlias> is the target work area alias name.

 Returns

     SELECT() returns the work area of the specified alias as an integer
     numeric value.

 Description

     SELECT() is a database function that determines the work area number of
     an alias.  The number returned can range from 0 to 250.  If <cAlias> is
     not specified, the current work area number is returned.  If <cAlias> is
     specified and the alias does not exist, SELECT() returns zero.

     Note:  The SELECT() function and SELECT command specified with an
     extended expression argument look somewhat alike.  This should not be a
     problem since the SELECT() function is not very useful on a line by
     itself.

 Examples

     .  This example uses SELECT() to determine which work area
        USE...NEW selected:

        USE Sales NEW
        SELECT 1
        ? SELECT("Sales")            // Result: 4

     .  To reselect the value returned from the SELECT() function, use
        the SELECT command with the syntax, SELECT (<idMemvar>), like this:

        USE Sales NEW
        nWorkArea:= SELECT()
        USE Customer NEW
        SELECT (nWorkArea)

 Files   Library is CLIPPER.LIB.


See Also: SELECT USE USED()
This page created by ng2html v1.05, the Norton guide to HTML conversion utility. Written by Dave Pearson