db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Gary Baker" <gary.ba...@movielink.com>
Subject Tables with foreign keys to themselves don't maintain Lists of related rows.
Date Tue, 23 Sep 2003 20:54:04 GMT
I've got a table with a foreign key to itself. 

Shouldn't the BaseXXX class maintain a List of related rows based on
that foreign key...

For example... 

<table name="XXX">
        <column name="XXX_ID" type="VARCHAR" size="40"
primaryKey="true"/>
        <column name="SUPER_ID" type="VARCHAR" size="40"/>
        <foreign-key foreignTable="XXX">
            <reference local="SUPER_ID" foreign="XXX_ID"/>
        </foreign-key>
</table>

Shouldn't there be a property on BaseXXX called collXxx of type List??
(there isn't one)
There are other tables with foreign keys to this table and such Lists
exist for those tables.
I'm using version 3.1?
Is this by design?  Or is this a short-coming?

Thanks,
-Gary

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message