ACOLUMNS()

Under Construction

Purpose

Function to load column names from the current database into an array and return the number of tables

Syntax

ACOLUMNS([<array>])

See Also

AADD(), AAVERAGE(), ACOLUMNS(), ACOPY(), ADATABASES(), ADEL(), ADESC(), ADIR(), AELEMENT(), AFIELDS(), AFILL(), AINS(), ALEN(), AMAX(), AMIN(), APPEND FROM ARRAY, ARRAY(), ASCAN(), ASIZE(), ASORT(), ASTORE(), ASTRING(), ASUBSCRIPT(), ASUM(), COPY TO ARRAY, DATABASE(), DECLARE, DIMENSION, DIR, FDATE(), FILE(), GATHER, IN_ARRAY(), IS_ARRAY(), LIST FILES, LOCAL, OPEN DATABASE, PRIVATE, PUBLIC, RELEASE, RESTORE, SAVE, SCATTER

Description

The ACOLUMNS() function loads the names of the tables (including the path) from the current database into an array and returns the number of tables / number of elements in the array. The name of the destination array is specified in <array>. The array does not need to be pre-declared.

Example

open database southwind
nTables = atables(table_arr)
? nTables