While writing an application that sucks meta-data from a database
using a variety of different methods I discovered the following
problem...
After calling SetSchemaInfo(stTables, '', '') on a
TSQLQuery component I retrieved a dataset that was missing the
"SCHEMA_NAME" column. Instead, the schema name was
included as a qualifier against each entry in the TABLE_NAME
column (eg. "MYSCHEMA"."MYTABLE"). All other columns
were present (RECNO, CATALOG_NAME, TABLE_NAME and
TABLE_TYPE) and correct.
The rough details of the set-up
were as follows:
Windows 2000
Delphi 6
Professional
IBM DB2 v7.2.1* Enterprise
Edition
dbExpress Open ODBC driver v1.03
IBM DB2
ODBC driver
* DB2 v7.2.1 is actually just 7.1 with latest
fixpaks applied
I must admit I'm not entirely sure this is a bug
with your driver, as I've checked the SQLMetaData related code
and I can't see anything immediately obvious that could be causing
this. It could be a bug in the DB2 ODBC driver, but looking at your
code I'm not too sure how a bug in the ODBC driver could cause
dbExpress to "forget" to add a column into the result set?
If
you need me to test or send anything further, please feel free to e-
mail me.
Log in to post a comment.
