Hello,

I have just downloaded the new version of LLBLGen and a problem that I did not have in the last version is occuring now: after creating a new project and adding all the entities from my database, a field of a table does not appear as a foreign key (this constraint has been added in the database of course). So when I generate the code the matching relation is missing. I really checked in my database to be sure this field was a foreign key and it is.

I hope you will be able to help me. Thanks in advance.

What kind of database do you use? Oracle, sqlserver... How recent did you download this version? If you refresh the catalog, is there a message in the Application Output window (docked at teh bottom of the llblgen pro designer) which says something like "FK ... rejected because it's not a correct FK). ? If so, please check if the FK's PK side is a primary key, not a unique constraint and that the FK is defined on the FK table (customer - Orders, fk should be defined on Orders, not customers)

Thank for the quick answer

I am using an oracle database (9i) and I downloaded the release from the 21 december (version 1.0.2004.1). I refreshed the catalog but I do not have a message saying a foreign has been rejected...

Naleo wrote:

Thank for the quick answer

I am using an oracle database (9i) and I downloaded the release from the 21 december (version 1.0.2004.1). I refreshed the catalog but I do not have a message saying a foreign has been rejected...

There is no message in the application output window at all?

It's a foreign key between two tables or between a table and a synonym?

Actually there are messages but this has nothing to see with the concerning table. I just copy past here in case:

CatalogRetriever::The following table(s) do not have a primary key present:
::[DB].[CREDIT]
::[DB].[DEPOT]
CatalogRetriever::The following table(s) do not have a primary key present:
::[DB].[CREDIT]
::[DB].[DEPOT]

The foreign key is between two tables. When I generate the code the mathing relation is missing in the both classes (the initial and the target ones).

Naleo wrote:

Actually there are messages but this has nothing to see with the concerning table. I just copy past here in case:

CatalogRetriever::The following table(s) do not have a primary key present:
::[DB].[CREDIT]
::[DB].[DEPOT]
CatalogRetriever::The following table(s) do not have a primary key present:
::[DB].[CREDIT]
::[DB].[DEPOT]

The foreign key is between two tables. When I generate the code the mathing relation is missing in the both classes (the initial and the target ones).

credit nor depot are in the fk missing?

Please send me: (to support@llblgen.com) - sql to recreate the two tables (no data, just the sql to create the two tables) - script (sql) which creates the PK's on the two tables - script which creates the FK's on the two tables.

This script has to be runnable from toad.