[<<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 a integer
numeric value.
Description
SELECT() is a database function that determines the work area number of
an alias. The number returned can range from zero 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 shouldn't 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:
ALIAS()
SELECT
USE
USED()
This page created by ng2html v1.05, the Norton guide to HTML conversion utility.
Written by Dave Pearson