SELECT()

From Recital Documentation Wiki
Revision as of 16:19, 7 December 2009 by Helengeorge (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Purpose

Function to return the current workarea number


Syntax

SELECT([<alias>])


See Also

SELECT, USE, ALIAS(), WORKAREA(), READVAR(), DBF()


Description

The SELECT() function returns the number of the currently selected workarea. If the optional <alias> is specified, the SELECT() function returns the workarea number for that alias. If the <alias> specified does not exist, the SELECT() function will return a 0.


Example

close all
? select()
         1
use prefixes in 3
? select ("prefixes")
         3
 
// Another Example
// to access each open workarea
m_count=0
select 1
do while not empty(alias())
  m_count = m->m_count + reccount()
  select select() + 1
enddo
dialog box "Total records in all tables is &m_count"


Products

Recital, Recital Server