Re: length of columns names
Posted in 2003
Ph. Chantry — — source: Usenet: comp.databases.informix
> > - 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 > > What are the more recent versions of the tools (isql, i4gl, r4gl) that > > manage correctly the true length of syscolumns.colname ? > > 7.32. Thank you.