Obtains a list of tables from the active connection
Usage:
dbTableNames (object me)
Parameter:
None
Returns:
( list of strings ) - a list of tables names in the active connection
Example:
xtRose = xtra("Rosetta").new( )
xtRose.dbOpen( "Provider=MSDASQL;ExtendedAnsiSQL=2;DRIVER={Microsoft Access Driver (*.mdb)};Dbq="&the moviepath&"main" )
put xtRose.dbTableNames( )
Notes:
Microsoft Excel don't deal with tables, instead a list of sheets are returned.
In many cases, dbTableNames( ) will also return the system table names. System tables are usually used by the data provider itself for self maintenance.
This function will return an empty list for those data formats that don't support multiple data sets, such as a Comma Delimited File(csv).