Tsession
Populates a string list with the names of tables associated with a specified database component.procedure GetTableNames(const DatabaseName, Pattern: String; Extensions, SystemTables: Boolean; List: TStrings);DescriptionCall GetTableNames to retrieve a list of the tables associated with a given database. DatabaseName specifies the name of the database from which to retrieve table names.Pattern specifies a delimiter string that restricts the tables returned to those that match the string. Pattern can include wildcard symbols. Pass an empty Pattern string to match all files not restricted by other criteria.For searches on Paradox and dBASE, set Extensions to True to include filename extensions as part of the table name. For SQL-based databases, set Extension to False.Set SystemTables to True for SQL-based databases to return both data tables and the system tables that define the database structure. Set SystemTables to False for Paradox and dBASE tables.List is a string list object, created and maintained by the application, into which to return the table names.
Populates a string list with the names of tables associated with a specified database component.procedure GetTableNames(const DatabaseName, Pattern: String; Extensions, SystemTables: Boolean; List: TStrings);DescriptionCall GetTableNames to retrieve a list of the tables associated with a given database. DatabaseName specifies the name of the database from which to retrieve table names.Pattern specifies a delimiter string that restricts the tables returned to those that match the string. Pattern can include wildcard symbols. Pass an empty Pattern string to match all files not restricted by other criteria.For searches on Paradox and dBASE, set Extensions to True to include filename extensions as part of the table name. For SQL-based databases, set Extension to False.Set SystemTables to True for SQL-based databases to return both data tables and the system tables that define the database structure. Set SystemTables to False for Paradox and dBASE tables.List is a string list object, created and maintained by the application, into which to return the table names.
try
Session.GetTableNames('DBDEMOS', '*.db',False, False, MyStringList);
{ Add the table names to a list box }
ListBox1.Items = MyStringList;
finally
MyStringList.Free;
end;
当然首选
adoconnection1.GetTableNames()