Revision as of 16:04, 20 March 2009

SELECT()

Class

Table Basics

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 Database Server, Recital Mirage Server, Recital Terminal Developer