Dear All,
I am trying out JDB by creating a database of football (Soccer) scores.
I create the following tables and everything runs smoothly:
load 'data/jdb'
NB. You must create the empty directory '~user/projects/football/data/jdb'
ffd =: Open_jdb_ jpath , '~user/projects/football/data/jdb' NB. football
folder
fdb =: Create__ffd 'football' NB. football database
matchdatetable =: Create__fdb 'matchdate' NB. stores the match dates
teamnametable =: Create__fdb 'teamname' NB. stores the team names
matchtable =: Create__fdb 'match' NB. stores the matches that have occurred
ftagtable =: Create__fdb 'ftag' NB. stores the Full Time Away Goals
InsertCols__fdb 'matchdate';'matchdate varchar;'
InsertCols__fdb 'teamname' ;'teamname varchar;'
InsertCols__fdb 'match'; 0 : 0
hometeam teamname
awayteam teamname
matchdate matchdate;
)
This all occurs without issues. Then when I try to insert the columns for
the results table (say the full time away goals):
InsertCols__fdb 'ftag'; 0 : 0
match match;
value int
)
, no error is generated but the system uses all of the processor for at
least 10 minutes. When I use jbreak to stop it from running I get:
|attention interrupt: dbsortdir
| dbsortdir''
Any thoughts?
Thanks,
Matthew.
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm
