Hello:
Hello!
CheckConstraint query
----------------
SELECT
null AS CONSTRAINT_CATALOG,
null AS CONSTRAINT_SCHEMA,
chktb.rdb$constraint_name AS CONSTRAINT_NAME,
chktb.rdb$relation_name AS TABLE_NAME,
trig.rdb$trigger_source AS CHECK_CLAUSULE,
trig.rdb$description AS DESCRIPTION
FROM rdb$relation_constraints chktb
left join rdb$check_constraints chk ON (chktb.rdb$constraint_name =
chk.rdb$constraint_name AND
chktb.rdb$constraint_type = 'CHECK')
left join rdb$triggers trig ON chk.rdb$trigger_name =
trig.rdb$trigger_name
---------------
This query return more excess rows(other constraints).
I don't understand this clause
--
left join rdb$check_constraints chk ON (chktb.rdb$constraint_name =
chk.rdb$constraint_name AND
chktb.rdb$constraint_type = 'CHECK')
--
may be inner join???(need only Check constraints)
Yeah it needs to be an inner join.
also I don't understand what to do method ParseRestrictions in
classes FbCheckConstraint and FbChecksByTable
Clearly nothing i will remove it.
Bot things should be now fixed in cvs for both 1.7 and 2.0 sources.
Thanks very much !!
--
Carlos Guzmán Álvarez
Vigo-Spain
http://carlosga.blogspot.com/
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$1720&dat1642
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
