[Solved] Get list of table names from existing database

[mic45267]

I have an embedded and registered database in a document and would like to get the list of available tables.
The database is using as datasource CSV files, thus the names of the tables may change.
I have tried to use:

Code: Select all

vDBSource = vDBContext.getByName("localdb")
vTableNames = vDBSource.TableFilter
for i= 0 to UBound(vTableNames())
Print vTableNames(i)
next i

but my result contains only one entry which is "%"
I have looked in "LibreOffice/Tools/TableFilter..." menu and all tables should be visible.

[Arineckaig]

Welcome to the Forum

I should warn you that VBasic does not readily transfer to the OpenOffice API which is designed to work with a variety of program languages and applications.
An introduction to StarBASIC however can be found at:
http://wiki.services.openoffice.org/wik ... ASIC_Guide
from which can be found code such as:

Code: Select all

oDatabaseContext = createUnoService("com.sun.star.sdb.DatabaseContext")
oDataSource = oDatabaseContext.getByName("localdb")
oTables = oDataSource.Tables
For I = 0 to oTables.Count -1
     print oTables(I).Name
Next

[mic45267]

Yes, thanks- this resolved my issue.
I was not aware of the DataSource property "Tables". (see http://www.openoffice.org/api/docs/comm ... ource.html)
Where is this defined?

[Arineckaig]

I was not aware of the DataSource property "Tables". . . . . .Where is this defined?

Alas, beyond my pay grade and limited understanding of the API. MRI suggests it could be the interface at:
http://www.openoffice.org/api/docs/comm ... plier.html.