View source for ASUBSCRIPT()

==Class==
Array Processing


==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()]], [[ASCAN()]], [[ASIZE()]], [[ASORT()]], [[ASTORE()]], [[ASTRING()]], [[ASUM()]], [[COPY TO ARRAY]], [[DECLARE]], [[DIMENSION]], [[GATHER]], [[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==
<code lang="recital">
use state.rdb
private aRECORDS[50,fcount()]
copy to array aRECORDS
nELEM = ascan(aRECORDS,'California')
? asubscript(aRECORDS,nELEM,1)
         6
</code>


==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
[[Category:Documentation]]
[[Category:Functions]]