Re: length of columns names

Ph. Chantry wrote: >>>- using ISQL 7.20.UD7, the result is false: >>>45 ceci_est_une_colon >> >>That's puzzling; you are running that in the Query-Language menu? > > Yes. > >>>- same false result with I4GL 7.20.UD7, R4GL 7.20.UD7 >> >>For this, you have to demonstrate with code what you are doing. > > > Here is the 4gl code. Tabid and colno correpond to my 45 characters test > column. > > database firstdb > main > DEFINE l_col CHAR(128) > select colname into l_col from testdb@testsrv:syscolumns > where tabid = 263 and colno = 1 > display l_col clipped > end main > > Result: > ceci_est_une_colon I dug out a 7.20.UD1 i4gl/r4gl installation and tested this code (very mildly modified) and sure enough, that's what I see. I don't have a good explanation of what's going on. I don't see how the I4GL or ESQL/C would be truncating the data - especially after I saved the value in a temporary table and then selected from that - so I have to conclude that somehow or another the server is confused. But I don't see how that works (fails) either. The observation is correct. The resolution is to upgrade to 7.3x I4GL. >>>What are the more recent versions of the tools (isql, i4gl, r4gl) that >>>manage correctly the true length of syscolumns.colname ? >> >>7.32. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/