To process more than one row, I would use ddfch instead, so change the line
dat =. ddfet sh,5
to
dat=. ddfch sh,5
then
+/ 0 ". > 6{dat
alternatively, you may use the following idiom when using ddfch,
'purch_ref from_whom description category ir_category date_purch amount
pay_method'=. dat
so that you can forget which index from dat
+/ 0 ". amount
> It seems that MySQL and J504 on Windows XP deliver strings of characters that
"look like" numbers.
I guess mysql often use sql decimal or numeric instead of double. It is the
odbc.ijs which maps sql decimal to J string. You may modify odbc.ijs script to
make it return true number in case you will used sql decimal fields daily.
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm
