David Mitchell wrote:
> NB. limitation: null,unicode,long data type not support
>
actually, all of them are supported.
case. <SQL_LONGVARBINARY do.
ln=. 1
(bname)=: ,a=. ln&{."1 brow&{ >(of+i){x
(blname)=: ,.rows#SQL_NULL_DATA
if you want to set any value of any data type in any row to null, just set the
corresponding item in (blname) to SQL_NULL_DATA. The real difficulty is how to
represent null in J data type.
I just always set long data to null, you may bind it to your values but I doubt
there wil be enough memory to do so.
--
regards,
bill
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm
