Difference between revisions of "WORKAREA()"

Revision as of 16:56, 8 December 2009

Purpose

Function to return the lowest available workarea number

Syntax

WORKAREA()

See Also

SELECT, USE, SET VIEW, USED(), DBRELATION(), DBRSELECT(), DBFILTER(), ALIAS(), SELECT()

Description

The WORKAREA() function returns the number of the lowest available workarea which is not in use. If all workareas are in use, it returns -1. The WORKAREA() function returns the number of the free workarea but it does not select that workarea. To determine the first free workarea AND select it, use SELECT 0 or SELECT WORKAREA().

Example

close databases
select 1
use state.rdb
? workarea()
         2
? select()
         1

Products

Recital, Recital Server