Difference between revisions of "SELECT()"

From Recital Documentation Wiki
Jump to: navigation, search
 
Line 1: Line 1:
=SELECT()=
 
 
 
==Class==
 
Table Basics
 
 
 
 
==Purpose==
 
==Purpose==
 
Function to return the current workarea number
 
Function to return the current workarea number

Revision as of 16:14, 28 October 2009

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