[<<Previous Entry]
[^^Up^^]
[Next Entry>>]
[Menu]
[About The Guide]
DBSELECTAREA()
Change the current work area
------------------------------------------------------------------------------
Syntax
DBSELECTAREA(<nArea> | <cAlias>) --> NIL
Arguments
<nArea> is a numeric value between zero and 250, inclusive, that
specifies the work area being selected.
<cAlias> is a character value that specifies the alias of a
currently occupied work area being selected.
Returns
DBSELECTAREA() always returns NIL.
Description
DBSELECTAREA() causes the specified work area to become the current work
area. All subsequent database operations will apply to this work area
unless another work area is explicitly specified for an operation.
DBSELECTAREA() performs the same function as the standard SELECT
command. For more information, refer to the SELECT command.
Notes
. Selecting zero: Selecting work area zero causes the lowest
numbered unoccupied work area to become the current work area.
. Aliased expressions: The alias operator (->) can temporarily
select a work area while an expression is evaluated and automatically
restore the previously selected work area afterward. For more
information, refer to the alias operator (->).
Examples
. The following example selects a work area via the alias name:
cLast := "Winston"
DBUSEAREA( .T., "DBFNTX", "Sales", "Sales", .T. )
DBSETINDEX( "SALEFNAM" )
DBSETINDEX( "SALELNAM" )
//
DBUSEAREA( .T., "DBFNTX", "Colls", "Colls", .T. )
DBSETINDEX( "COLLFNAM" )
DBSETINDEX( "COLLLNAM" )
//
DBSELECTAREA( "Sales" ) // select "Sales" work area
//
IF ( Sales->(DBSEEK(cLast)) )
IF Sales->( DELETED() ) .AND. Sales->( RLOCK() )
Sales->( DBRECALL() )
? "Deleted record has been recalled."
ENDIF
ELSE
? "Not found"
ENDIF
Files Library is CLIPPER.LIB.
See Also:
DBUSEAREA()
RLOCK()
UNLOCK
SELECT
SELECT()
RLOCK()
This page created by ng2html v1.05, the Norton guide to HTML conversion utility.
Written by Dave Pearson