Difference between revisions of "ATABLES()"
Yvonne.milne (Talk | contribs) m (1 revision) |
Barrymavin (Talk | contribs) |
||
(3 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Function to load table names from the current database into an array and return the number of tables | Function to load table names from the current database into an array and return the number of tables | ||
− | |||
==Syntax== | ==Syntax== | ||
ATABLES(<array>) | ATABLES(<array>) | ||
− | |||
==See Also== | ==See Also== | ||
− | [[AADD()]], [[AAVERAGE()]], [[ | + | [[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== | ==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. | 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== | ==Example== | ||
Line 22: | Line 18: | ||
</code> | </code> | ||
− | |||
− | |||
− | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
− | [[Category: | + | [[Category:Cursor Functions]] |
[[Category:Array Processing Functions]] | [[Category:Array Processing Functions]] |
Latest revision as of 23:38, 20 May 2018
Contents
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