Get Table list

[#1]

I have over 400 tables and need to be able to programmatically get a list of the table names. (They change based upon field names associated with values within the database.)

How do I do this?

[rustyfishbones · Accepted solution]

Create a list box expression

and say

[#3]

Hah. I knew it would be something obvious.

Thank you!

[marcus_sommer]

In gui you could use the system-fields in various objects, there is for example an own object structure table. In script you could use table- and field-functions in a loop:

for i = 1 to nooftables() - 1

     Tables:

     Load i as nr, tablename(i) as Table autogenerate 1;

next

-  Marcus