Last table number
Last table number : Integer
| Parameter | Type | Description | |
|---|---|---|---|
| Function result | Integer | ← | Highest table number in the database |
Description
Last table number returns the highest table number among the tables in the database. Tables are numbered in the order in which they are created. If no table has been deleted from the database, this command then returns the number of tables present in the database. In the case of repeated loops on the table numbers of the database, you must use the Is table number valid command in order to check that the table has not been deleted.
Example
The following example builds an array, named asTables*,* with the names of tables defined in the database. This array can be used as a drop-down list (or tab control, scrollable area, and so on) to display the list of the tables, within a form:
ARRAY TEXT(asTables;Last table number)
If(Last table number>0) //If the database does contain tables
For($vlTables;Size of array(asTables);1;-1)
If(Is table number valid($vlTables))
asTables{$vlTables}:=Table name($vlTables)
Else
DELETE FROM ARRAY(asTables;$vlTables)
End if
End for
End if