Hey guys:
when using your DLL, GetTableNames returns the tables from the DB, but the SCHEMA_NAME column is null.
Is this a implementation decision? a Bug? Any other way to retrieve table names and the schema these tables belong without asking it directly to the DB (SELECT * FROM information_schema.tables)
Thanks
--
Jackson Gomes
GetTableNames and Schema Name
Re: GetTableNames and Schema Name
Hello,
To obtain tables, we use a query that returns the same data as the standard driver does. Please clarify, where can't you get data about SCHEMA_NAME?
To obtain tables, we use a query that returns the same data as the standard driver does. Please clarify, where can't you get data about SCHEMA_NAME?
Re: GetTableNames and Schema Name
You should used DBX4 fetching Metadata function.JacksonGomes wrote:Hey guys:
when using your DLL, GetTableNames returns the tables from the DB, but the SCHEMA_NAME column is null.
Is this a implementation decision? a Bug? Any other way to retrieve table names and the schema these tables belong without asking it directly to the DB (SELECT * FROM information_schema.tables)
Thanks
--
Jackson Gomes
See also:
-Fetching Metadata into a dbExpress Dataset (http://docwiki.embarcadero.com/RADStudi ... ss_Dataset)
-dbExpress SetSchemaInfo is miss (Chinese) (http://grandruru.blogspot.tw/2015/04/db ... ainfo.html)
Re: GetTableNames and Schema Name
To set the Schema value, you can use the SchemaOverride parameter.