Difference between revisions of "ACOL()"

Latest revision as of 13:48, 26 July 2010

Purpose

Function to return a column coordinate from an array

Syntax

ACOL()

See Also

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

Description

The ACOL() function returns a column coordinate from an array. The ACOL() function may be used in conjunction with the AROW() function as part of a UDF for the ABROWSE() function. The ABROWSE() function browses a two-dimensional array in spreadsheet style format, and accepts an optional UDF to define keystrokes.

When not used in a UDF for the ABROWSE() function, the ACOL() and AROW() functions may be used to return the position in the array on exit. See the [ABROWSE()-] entry for an example of the use of the AROW() and ACOL() functions within an ABROWSE() user defined function.

Example

use customer.rdb
declare acust[lastrec(),fcount()]
copy to array acust
clear
abrowse(1,1,23,78,acust)
dialog box acust[arow(), acol()]

Products

Recital