Птн, 18 Июн 2010, Cox, Ed писал(а): > I seem to have found a way to make the TinyInt and Bit data types work in > ODBC (with Windows XP and SQL Server). I am not entirely sure I understand > why they work, so if anyone understands this enough to tell if this is a > reliable fix it would be really appreciated. > > Here is what I did. In ODBC.ijs, I modified the verb bindcol. It had the > following lines originally: > elseif. type e. SQL_BIT, SQL_TINYINT do. > len=. 1 [ tartype=. SQL_DEFAULT > (bname)=: (rows,len)$' ' > > I changed that to be: > elseif. type e. SQL_BIT do. > len=. 1 [ tartype=. SQL_TINYINT > (bname)=: (rows,len)$0 > elseif. type e. SQL_TINYINT do. > len=. 1 [ tartype=. SQL_INTEGER > (bname)=: (rows,len)$2-2
I'm not sure, but len=. SZI seems more reasonable, at least for SQL_INTEGER. -- regards, ==================================================== GPG key 1024D/4434BAB3 2008-08-24 gpg --keyserver subkeys.pgp.net --recv-keys 4434BAB3 ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
