Not sure I really understand this, but if "midkey" has unique values, e.g.
Insert__hd 'middletable';< (<0 0;100 200),0 1;0 0 NB. Instead of Insert__hd 'middletable';< (<0 0;100 200),0 0;0 0 You get +-------+---+ |lowkey2|200| +-------+---+ from the read statement. On Tue, Sep 22, 2009 at 4:38 PM, Tirrell, Jordan (Consultant) < [email protected]> wrote: > In JDB, when adding data to a table referencing a table which is > referencing a third table I run into a problem where the data doesn't > match what I put in. Try the following example: > > > > load 'data/jdb' > > hf=: Open_jdb_ dirpath NB. dirpath is directory to save database > > hd=: Create__hf 'sample' > > > > Create__hd 'lowertable';'lowkey1 int, lowkey2 int; low int' > > Insert__hd 'lowertable';< 0 0;100 200;0 0 > > > > Create__hd 'middletable';'lowid lowertable,midkey int;mid int' > > Insert__hd 'middletable';< (<0 0;100 200),1 1;0 0 > > > > Create__hd 'uppertable';'midid middletable,upkey int;up int' > > Insert__hd 'uppertable';< (<(<0;200),<1),0;0 > > > > Read__hd 'lowkey2 from uppertable' > > > > This gives me a value of 100 for lowkey2 from uppertable (it should be > 200). Does anyone see a mistake or have any ideas where a bug could be? > > > > Thanks, > > Jordan > > ---------------------------------------------------------------------- > For information about J forums see http://www.jsoftware.com/forums.htm > -- Devon McCormick, CFA ^me^ at acm. org is my preferred e-mail ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
