Is there something wrong with the JDB code below? I think it should result
in:
('home';'away'),:('TEAMA');('TEAMB')
But instead it results in:
('home';'away'),:('TEAMA');('TEAMA')
Thanks,
Matthew.
load 'data/jdb'
ffd =: Open_jdb_ jpath , '~temp'
db =: Create__ffd 'testdb'
Create__db 'teamname';0 : 0
value varchar;
)
NB. create table to store unique matches
matchtb =: Create__db 'match';0 : 0
home teamname
away teamname;
)
NB. insert some team names
Insert__db 'teamname';<<'TEAMA';'TEAMB'
NB. insert record that TEAMA played at home against TEAMB
Insert__db 'match';<(('TEAMA');('TEAMB'))
NB. The insert has not worked correctly:
Reads__db 'home, away from match'
NB. It should look like:
('home';'away'),:('TEAMA');('TEAMB')
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm
