For now I added in rev.23163 schema name into query for PostgreSQL (so
no empty schema name is returned, but valid schema name)
Here I understand:
stTables - list of all tables, which may include system tables (it is
not clear from documentation)?
stSysTables - list of ONLY system tables (not views)
http://docwiki.embarcadero.com/Libraries/XE2/en/Data.SqlExpr.TSQLConnection.GetTableNames
"If SystemTables is true, only the system tables are added to List. If
SystemTables is false, the list is filled with any tables that match the
criteria specified by the TableScope
<http://docwiki.embarcadero.com/Libraries/XE2/en/Data.SqlExpr.TSQLConnection.TableScope>
property"
http://docwiki.embarcadero.com/Libraries/XE2/en/Data.SqlExpr.TCustomSQLDataSet.SetSchemaInfo
"stTables - Information about all the data tables on the database
server that match the criteria specified by the SQL connection's
TableScope
<http://docwiki.embarcadero.com/Libraries/XE2/en/Data.SqlExpr.TSQLConnection.TableScope>
property."
"stSysTables - Information about all of the system tables on the
database server"
"If an application calls GetTablesNames with SystemTables set to true,
or calls SetSchemaInfo
<http://docwiki.embarcadero.com/Libraries/XE2/en/Data.SqlExpr.TCustomSQLDataSet.SetSchemaInfo>
with SchemaType set to stSysTables, system tables, and only system
tables are returned, regardless of the value of *TableScope*."
-Laco.
_______________________________________________
fpc-pascal maillist - fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/mailman/listinfo/fpc-pascal
