Re: Capture foreign key fails (Designer Editor 6.5.40.3.0)

From: Van Messner <vmessner_at_bestweb.net>
Date: Thu, 01 Feb 2001 23:27:38 GMT
Message-ID: <Khme6.1758$9q6.252273_at_newshog.newsread.com>


I don't know what's causing your problem, but it's not that the column names are different.

Van

"Stefan Schindler" <schindler_at_self.de> wrote in message news:3A77D9FF.5F424664_at_self.de...
> Hi!
>
> I cannot capture some of my foreign key neither from an existing
> database (Oracle 8.1.7) nor from a script.
> The script command reads
>
> ALTER TABLE TAB_A ADD (CONSTRAINT
> FK_NAME FOREIGN KEY
> (COL_A) REFERENCES TAB_B
> (COL_B))
> /
>
> The resulting error message reads:
> _____
>
> CDS-15017 Warning: Column 'COL_A' is inconsistent with foreign column
> 'COL_B' - in foreign key 'FK_NAME' of table 'TAB_A'
>
> Cause:
> The related object definitions are inconsistent (e.g. a foreign key
> column datatype differs from that of the referenced table column)
>
> Action:
> Change one of the two objects definition
> ___
>
> Now let's examine the columns and the behaviour of Designer Editor
> 6.5.40.3.0:
> * The types of the columns are identical (eg. varchar2(80) )
> * The names of the columns differ (might be the reason ? )
> * A foreign key can be created within Designer8i manually
> * Generating a DDL-script and recapturing the foreign key expression
> leaves me without an error message (the foreign key exists)
> * Deleting the entry from the repository and recapturing the foreign key
> expression from the generated script comes up with CDS-15017
>
> "Capturing the froreign key expression" means editing the generated
> "sql.con" script and removing everything except the ALTER TABLE ...
> command shown at the beginning of this question.
>
> Can anybody explain what's going on and point me the way how to capture
> / import a real bulk of such foreign keys from a productive database?
>
> Thanks in advance
>
> Stefan J. Schindler
>
>
Received on Fri Feb 02 2001 - 00:27:38 CET

Original text of this message