WORKAREA()

From Lianjapedia
Jump to: navigation, search

Purpose

Function to return the lowest available workarea number

Syntax

WORKAREA()

See Also

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

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