I'll see.. I'm grateful for the input even if not.. But I've been doing
that :'( ..
To clarify
<column name="APPLICATION_ID" type="INTEGER"/>
<foreign-key foreignTable="APPLICATION">
<reference local="APPLICATION_ID" foreign="APPLICATION_ID"/>
</foreign-key>
..and then in the foreign table..
<column name="APPLICATION_ID" primaryKey="true" required="true"
type="INTEGER" autoIncrement="true" javaName="Id" />
Thanks Mark
On Tuesday, August 12, 2003, at 05:44 PM, Sgarlata Matt wrote:
> In my experience, they usually do work as long as the foreign key is
> to the
> primary key of the foreign table. If the foreign key is to an
> alternate
> key, they do not work because Torque gets confused and thinks you
> really
> meant to have a foreign key to the primary key. I Hope that makes
> sense...
>
> Matt
> ----- Original Message -----
> From: "Mark Lowe" <mark.lowe@talk21.com>
> To: "Turbine List" <torque-user@db.apache.org>
> Cc: <torque-dev@db.apache.org>
> Sent: Tuesday, August 12, 2003 12:38 PM
> Subject: Foreign keys another great mystery...
>
>
>> Okay I'm going to make this really easy..
>>
>> Do foreign keys and the subsequent methods generated from such entries
>> in a schema actually work? Or are they just trying to look nice?
>> Please
>> tell me somebody, tell me point me to some reading or something, i'm
>> not being lazy. I don't mind if this isn't supported although I jaded
>> that nobody seems to document any of the stuff that doesn't work ever
>> and its left as if it does...
>>
>> Many thanks
>>
>> Mark
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
>> For additional commands, e-mail: torque-dev-help@db.apache.org
>>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-dev-help@db.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org
|