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
