Difference between revisions of "WORKAREA()"

From Recital Documentation Wiki
Jump to: navigation, search
 
 
(2 intermediate revisions by one user not shown)
Line 1: Line 1:
=WORKAREA()=
 
 
 
==Class==
 
Environment
 
 
 
 
==Purpose==
 
==Purpose==
 
Function to return the lowest available workarea number
 
Function to return the lowest available workarea number
Line 15: 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()]]
  
  
Line 35: Line 28:
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital, Recital Server
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Functions]]
 
[[Category:Functions]]

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