LLBLGen v2.6 Self-Servicing Mapped Fields

Posts   
 
    
mshe
User
Posts: 167
Joined: 02-Feb-2006
# Posted on: 04-Jan-2011 20:38:37   

Hi All,

I have multiple inherited entities that have a field mapped on a relation:

Parent Table (PK - MyID) Child 1 -----> Mapped Table (PK - MyID) Child 2 -| Child 3

Both Child 1 and Child 2 are linked to the Mapped table. The PK among the Parent Table = Child 1's PK = Mapped Table.

I am using per table inheritance.

LLBLGen seems to generate the relationship fine, but when I try to assign a value to the mapped entity, nothing happens. SetValue just seems to return without setting the underlying property values.

I even tried using MyObject.MappedObject.SetNewFieldValue and it does not work (function returns true, but property is not set).

The generated SQL also reflects the fact no values were assigned.



            MyObject.Recordid = Record.ID.ToString
            MyObject.Clientid = 1
            MyObject.Serverid = 2
            MyObject.Entrydate = Record.RecordTime
            MyObject.Type = "MyTest"

            With MyObject.MappedObject
                .Id = 12345 'This does not work 
                .Identifer = "Hello World" 'This does not work
            End With


Any ideas?

I'm running the latest runtimes for v2.6. Oracle 10g database.

Thanks.

MTrinder
User
Posts: 1461
Joined: 08-Oct-2008
# Posted on: 04-Jan-2011 21:27:00   

I'm not sure I entirely understand your schema - what is "Mapped Table" - is this the table that contains the sub-type entities...?

Matt

mshe
User
Posts: 167
Joined: 02-Feb-2006
# Posted on: 06-Jan-2011 05:25:06   

MTrinder wrote:

I'm not sure I entirely understand your schema - what is "Mapped Table" - is this the table that contains the sub-type entities...?

Matt

Turns out it was a database schema error - chicken and egg scenario, I think this caused some issues with the designer?

Anyhow, I redid the database schema to work around the issue.

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 06-Jan-2011 06:28:09   

I don't see any obvious reason, unless you can reproduce it again step by step. Fortunately you solved it wink

David Elizondo | LLBLGen Support Team