I got an error on the following:
case. SQL_TYPE_DATE;SQL_TYPE_TIME;SQL_TYPE_TIMESTAMP do.
if. 2 e.~ 3!:0 data do.
due to 'data' being undefined.
Possible fix:
case. SQL_TYPE_DATE;SQL_TYPE_TIME;SQL_TYPE_TIMESTAMP do.
data=.>(of+i){x NB. DM 2006 07 24
if. 2 e.~ 3!:0 data do.
A bit of documentation on ddins would be helpful also. Perhaps:
NB. usage (sql;data1;data2;...) ddins ch
NB. sql is a select statement
NB. data1,data2,... are rank-2 vectors
NB. eg. ch ddins~ 'select account,amount from
chart';(>'apple';'orange';'cherry'); ,.100 300 200
NB. limitation: null,unicode,long data type not support
David Mitchell
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm
