At 10:29 PM 15/04/2006, you wrote:

>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

It's a known incompatibility. IBO 4.6 isn't 100% ready for Fb 2.0 yet.

>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.

Be patient...there's an update due shortly that will address the
remaining incompatibilities introduced with Fb 2.0.

What can you do? Use Fb 1.5.3 until Fb 2.0 is released.

Helen