ATABLES()

From Lianjapedia
Jump to: navigation, search

Purpose

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

Syntax

ATABLES(<array>)

See Also

AADD(), AAVERAGE(), 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 ATABLES() 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