db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Charles-Alexandre Sabourdin <kan...@dedaletechnology.com>
Subject Re: foreign key in another database
Date Wed, 17 Dec 2003 13:09:17 GMT
To me this beaviour is forbiden in SQL, but you can map (link) one table from 
a database  to another table in a other database.

Le Mercredi 17 Décembre 2003 00:36, Charles N. Harvey III a écrit :
> Hello.
> I have been looking through the mail-archives and I don't seem to
> be able to come up with the answer.  I am probably missing it somewhere
> but I thought I'd try the list.
>
> I have two schema files in my schema directory.  Because I am using two
> databases for this project.  But, sometimes the foreign key in a table
> is referencing a table that is in the other database.  Torque blows up
> at this point and doesn't let me use this.
>
> Is this because it isn't allowed in sql (mssql for me)?  Or is it a
> "limitation" of torque?  I want to create my java files and they don't
> care what database tables are in.  They just need to relate to each
> other.  So I just want torque to skip over the fact that the table is
> in another database and carry on like it usually would.
>
> Is this possible?
>
> Thanks a lot.
>
>
> Charlie
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org

-- 
Charles-Alexandre
SABOURDIN
-----------------


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message