How many tables and how many rows in each table would you have? 2009/9/24 Tirrell, Jordan (Consultant) <[email protected]>
> I'm using a simple workaround right now where I put duplicate columns in > the unique part of the middle table for the columns which reference the > lower table, so that the structure is identical except that the upper > table sees the uniqueness directly in the middle table now because of > these duplicate columns. This seems to work on the sample data and I'm > currently trying it for a much larger database, but I'd still like to > get an actual fix eventually. Does anyone else use JDB regularly for > large databases? > > Jordan > > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of Tirrell, Jordan > (Consultant) > Sent: Wednesday, September 23, 2009 2:28 PM > To: Programming forum > Subject: Re: [Jprogramming] JDB wrong data > > My understanding is when you reference another table you are referencing > the hidden column autoid, which indexes its unique columns. So a > reference to another table is always to its unique columns. Unique > columns are only needed in the table being referenced to, which my > example has (upper table references the unique 0 100 1 and 0 200 1 from > middletable, which in turn reference the unique 0 100 and 0 200 from > lowertable). The problem, as Devon found, is that JDB doesn't seem to > handle references to unique data which is unique only by reference to > another table (that is, if we instead had 0 100 0 and 0 200 1 in > middletable we'd be fine, since the uniqueness is in middletable without > its reference to lowertable). > > Jordan > > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of Raul Miller > Sent: Wednesday, September 23, 2009 11:59 AM > To: Programming forum > Subject: Re: [Jprogramming] JDB wrong data > > On Tue, Sep 22, 2009 at 11:52 PM, Devon McCormick <[email protected]> > wrote: > > Not sure I really understand this, but if "midkey" has unique values, > > JDB's documentation says it expects unique columns > for references to other tables. > > -- > Raul > ---------------------------------------------------------------------- > For information about J forums see http://www.jsoftware.com/forums.htm > ---------------------------------------------------------------------- > For information about J forums see http://www.jsoftware.com/forums.htm > ---------------------------------------------------------------------- > For information about J forums see http://www.jsoftware.com/forums.htm > ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
