Subject | Browsing problem. |
---|---|
Author | Malav A Shah |
Post date | 2006-04-15T12:29:58Z |
hi all,
Currently I am using IB Object v4.6 and firebird 2.0. but when i
m trying to browse the database it gives me error
"Invalid Column RDB$Relation_Constraints.RDB$Relation_Name."
After referring to the firebird 2.0 i came to know that in firebird
2.0 if table alias is declared then you must use alias entirely. The
query which IB Sql uses for browsing the database is
SELECT RC.RDB$CONSTRAINT_NAME
, RC.RDB$CONSTRAINT_TYPE
, RC.RDB$DEFERRABLE
, RC.RDB$INITIALLY_DEFERRED
, RC.RDB$INDEX_NAME
, FC.RDB$CONST_NAME_UQ
, FC.RDB$UPDATE_RULE
, FC.RDB$DELETE_RULE
, (SELECT RC2.RDB$RELATION_NAME
FROM RDB$RELATION_CONSTRAINTS RC2
WHERE RC2.RDB$CONSTRAINT_NAME =
FC.RDB$CONST_NAME_UQ) PARENT_RELATION
FROM RDB$RELATION_CONSTRAINTS RC
LEFT
JOIN RDB$REF_CONSTRAINTS FC
ON RC.RDB$CONSTRAINT_NAME = FC.RDB$CONSTRAINT_NAME
WHERE RDB$RELATION_CONSTRAINTS.RDB$RELATION_NAME=? /*
MLNK_RDB$RELATION_NAME_0 */
ORDER BY RC.RDB$CONSTRAINT_NAME ASC
So can we modify the query which is fired internally. if yes how.
if no then plz give me suggestion to over come this problem.
Currently I am using IB Object v4.6 and firebird 2.0. but when i
m trying to browse the database it gives me error
"Invalid Column RDB$Relation_Constraints.RDB$Relation_Name."
After referring to the firebird 2.0 i came to know that in firebird
2.0 if table alias is declared then you must use alias entirely. The
query which IB Sql uses for browsing the database is
SELECT RC.RDB$CONSTRAINT_NAME
, RC.RDB$CONSTRAINT_TYPE
, RC.RDB$DEFERRABLE
, RC.RDB$INITIALLY_DEFERRED
, RC.RDB$INDEX_NAME
, FC.RDB$CONST_NAME_UQ
, FC.RDB$UPDATE_RULE
, FC.RDB$DELETE_RULE
, (SELECT RC2.RDB$RELATION_NAME
FROM RDB$RELATION_CONSTRAINTS RC2
WHERE RC2.RDB$CONSTRAINT_NAME =
FC.RDB$CONST_NAME_UQ) PARENT_RELATION
FROM RDB$RELATION_CONSTRAINTS RC
LEFT
JOIN RDB$REF_CONSTRAINTS FC
ON RC.RDB$CONSTRAINT_NAME = FC.RDB$CONSTRAINT_NAME
WHERE RDB$RELATION_CONSTRAINTS.RDB$RELATION_NAME=? /*
MLNK_RDB$RELATION_NAME_0 */
ORDER BY RC.RDB$CONSTRAINT_NAME ASC
So can we modify the query which is fired internally. if yes how.
if no then plz give me suggestion to over come this problem.