Relations and Oracle Schemas

Posts   
 
    
Blue9
User
Posts: 3
Joined: 10-Oct-2005
# Posted on: 10-Oct-2005 15:52:31   

I'm trying to create a custom entity relation between two tables residing in two different Oracle schemas, on the same Oracle DB. I can't get this to work, is it just me or isn't this supported by LLBLGen Pro 1.0.2004.2 Final Released August 5th 2004?

Drewes
User
Posts: 67
Joined: 18-Aug-2003
# Posted on: 11-Oct-2005 03:53:09   

This is supported. There are two things to keep in mind: 1 Types have to be the same 2 One side has to be a PK, not a unique constraint (surrogate key).

If this is the case and you still have a problem let us know.

Blue9
User
Posts: 3
Joined: 10-Oct-2005
# Posted on: 11-Oct-2005 09:07:28   

Here is some additional information regarding my objects that I'm using.

Schema: Markus Table: Article Field: ART_NR VARCHAR2(9) Is part of primary key [V]

Schema: Report Table: LogisticsServiceDegreeDay Field: ART_NR VARCHAR2(6) Is part of primary key [V]

For the table "LogisticsServiceDegreeDay" the "Is part of primary key" is set in LLBLGen. Then I try to created a relation from the entity called Article. I choose the LogisticsServiceDegreeDay entity as "and related to" and then as I try to select the "Foreign Key field name" there aren't any showing.

Could the problem be that the fields differ regarding the length of the VARCHAR2?

I can create relations to the Article entity from other data tables within the Markus schema.

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39614
Joined: 17-Aug-2003
# Posted on: 11-Oct-2005 09:41:24   

Length is different, which means in 1.0.2004.2, the relation can't be created. In 1.0.2005.1 this is changed to 'same .NET type'. (now in beta) Sorry for this inconvenience.

Frans Bouma | Lead developer LLBLGen Pro
Blue9
User
Posts: 3
Joined: 10-Oct-2005
# Posted on: 11-Oct-2005 09:58:06   

Is there a planned launch date for the new version?

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39614
Joined: 17-Aug-2003
# Posted on: 11-Oct-2005 11:07:55   

Blue9 wrote:

Is there a planned launch date for the new version?

As soon as the docs are done and the quality is up to par. We had a release date in mind somewhere this week, but I think it will be next week.

Frans Bouma | Lead developer LLBLGen Pro