Difference between revisions of "WORKAREA()"

From Recital Documentation Wiki
Jump to: navigation, search
(Products)
 
Line 8: Line 8:
  
 
==See Also==
 
==See Also==
[[SELECT]], [[USE]], [[SET VIEW]], [[USED()]], [[DBRELATION()]], [[DBRSELECT()]], [[DBFILTER()]], [[ALIAS()]], [[SELECT()]]
+
[[ALIAS()]], [[DBRELATION()]], [[DBRSELECT()]], [[DBFILTER()]], [[SELECT]], [[SELECT()]], [[SET VIEW]], [[USE]], [[USED()]]
  
  

Latest revision as of 16:29, 15 December 2009

Purpose

Function to return the lowest available workarea number


Syntax

WORKAREA()


See Also

ALIAS(), DBRELATION(), DBRSELECT(), DBFILTER(), SELECT, SELECT(), SET VIEW, 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


Products

Recital, Recital Server