Hi Jiri,
i found one little mistake in GetSchemaCommandText() function of
FbDataReader (i downloaded source and binary just few minutes ago)
so, we have following sql statement
SELECT
fld.rdb$computed_blr AS computed_blr,
fld.rdb$computed_source AS computed_source,
(SELECT COUNT(*) FROM rdb$relation_constraints rel
INNER JOIN rdb$indices idx ON rel.rdb$index_name =
idx.rdb$index_name
INNER JOIN rdb$index_segments seg ON
idx.rdb$index_name = seg.rdb$index_name
WHERE rel.rdb$constraint_type = 'PRIMARY KEY'
AND rel.rdb$relation_name = rfr.rdb$relation_name
AND seg.rdb$field_name = rfr.rdb$field_name) AS
primary_key,
(SELECT COUNT(*) FROM rdb$relation_constraints rel
INNER JOIN rdb$indices idx ON rel.rdb$index_name =
idx.rdb$index_name
INNER JOIN rdb$index_segments seg ON
idx.rdb$index_name = seg.rdb$index_name
WHERE rel.rdb$constraint_type = 'UNIQUE'
AND rel.rdb$relation_name = rfr.rdb$relation_name
AND seg.rdb$field_name = rfr.rdb$field_name) AS
unique_key,
fld.rdb$field_precision AS numeric_precision
FROM rdb$relation_fields rfr
INNER JOIN rdb$fields fld ON rfr.rdb$field_source =
fld.rdb$field_name
WHERE [r]fr.rdb$relation_name = ?
AND rfr.rdb$field_name = ?
ORDER BY rfr.rdb$relation_name, rfr.rdb$field_position
do you see the bolded "r"-letter (the third line from the end) ? it is not
present in source code, that brings sql syntax error :)
--
View this message in context:
http://www.nabble.com/Misprint-in-FbDataReader.cs-of-latest-build-tp14753060p14753060.html
Sent from the firebird-net-provider mailing list archive at Nabble.com.
-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
