[<<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