Hello:
Two questions: Any idea how I should go about debugging this? Is there
a connection string setting I should be looking at? I'm still getting
empty strings for default values (xml version of my dataset is
attached). And, once I get it working, is there a function to submit
changes to the schema back to the database or do I need to create ddl
and execute it?
The command executed by the provider in my case looks like this:
SELECT
null AS TABLE_CATALOG,
null AS TABLE_SCHEMA,
rfr.rdb$relation_name AS TABLE_NAME,
rfr.rdb$field_name AS COLUMN_NAME,
null AS COLUMN_DATA_TYPE,
fld.rdb$field_sub_type AS COLUMN_SUB_TYPE,
cast(fld.rdb$field_length AS integer) AS COLUMN_SIZE,
cast(fld.rdb$field_precision AS integer) AS NUMERIC_PRECISION,
cast(fld.rdb$field_scale AS integer) AS NUMERIC_SCALE,
cast(fld.rdb$character_length AS integer) AS "CHARACTER_LENGTH",
cast(fld.rdb$field_length AS integer) AS CHARACTER_OCTET_LENGTH,
rfr.rdb$field_position AS ORDINAL_POSITION,
null AS DOMAIN_CATALOG,
null AS DOMAIN_SCHEMA,
rfr.rdb$field_source AS DOMAIN_NAME,
rfr.rdb$default_source AS COLUMN_DEFAULT,
fld.rdb$computed_source AS COMPUTED_SOURCE,
fld.rdb$dimensions AS IS_ARRAY,
rfr.rdb$null_flag AS IS_NULLABLE,
0 AS IS_READONLY,
fld.rdb$field_type AS FIELD_TYPE,
null AS CHARACTER_SET_CATALOG,
null AS CHARACTER_SET_SCHEMA,
cs.rdb$character_set_name AS CHARACTER_SET_NAME,
null AS COLLATION_CATALOG,
null AS COLLATION_SCHEMA,
coll.rdb$collation_name AS COLLATION_NAME,
rfr.rdb$description AS DESCRIPTION
FROM
rdb$relation_fields rfr
left join rdb$fields fld ON rfr.rdb$field_source = fld.rdb$field_name
left join rdb$character_sets cs ON cs.rdb$character_set_id =
fld.rdb$character_set_id
left join rdb$collations coll ON (coll.rdb$collation_id =
fld.rdb$collation_id AND coll.rdb$character_set_id =
fld.rdb$character_set_id)
WHERE
rfr.rdb$relation_name = 'USERPREFERENCES'
ORDER BY
rfr.rdb$relation_name, rfr.rdb$field_position
Try to run it from IBExpert or similar and let me know if the column
gets values or not.
--
Carlos Guzmán Álvarez
Vigo-Spain
http://carlosga.blogspot.com/
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid3432&bid#0486&dat1642
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
