Difference between revisions of "ASUBSCRIPT()"

Revision as of 10:18, 5 November 2009

Purpose

Function to return the row or column number of an array element from the element number

Syntax

ASUBSCRIPT(<array>, <expN1> ,<expN2>)

See Also

AADD(), AAVERAGE(), ABROWSE(), ACHOICE(), ACOL(), ACOPY(), ADEL(), ADESC(), ADIR(), AELEMENT(), AFIELDS(), AFILL(), AINS(), ALEN(), AMAX(), AMIN(), APPEND FROM ARRAY, AROW(), ARRAY(), ASCAN(), ASIZE(), ASORT(), ASTORE(), ASTRING(), ASUM(), COPY TO ARRAY, DECLARE, DIMENSION, GATHER, IN_ARRAY(), LOCAL, PRIVATE, PUBLIC, RELEASE, RESTORE, SAVE, SCATTER

Description

The ASUBSCRIPT() function returns the array <array> row or column element reference for a specified array element. The parameter <expN1> defines the array element index position within the array. The parameter <expN2> identifies whether the array's row or column reference should be returned. If <expN2> is a 1, the row number is returned. If <expN2> is a 2, the column number is returned.

Example

use state.rdb
private aRECORDS[50,fcount()]
copy to array aRECORDS
nELEM = ascan(aRECORDS,'California')
? asubscript(aRECORDS,nELEM,1)
         6

Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer