Re: moving from 7.31

ogj@tollpost.no wrote: > "Obnoxio The Clown" <obnoxio@serendipita.com> writes: >>John Lynch (IS) said: >>> We are currently migrating our 4gl application from Hp_UX, IDS >>>7.31.Fd6 to IDS 9.4 (also on HP-UX) for the moment. >>> One thing we noticed is a syntax error now occurs at runtime on a >>>SELECT stmt such as >>> >>> SELECT ref FROM table1 (works under 7.31 compiled with r4gl 7.30 >>>FC4, but not on IDS 9.40 compiled with r4gl 7.32) Compile time or runtime error? >>> On 9.4 we need to say SELECT table1.ref from table1 for it to work. >>>Is ref a reserved word under 9.4 and if so >>> are there any more new Reserved words we should know about. >> >>I'm surprised they weren't in the release notes. You did read the release >>notes, didn't you? Or the section in the migration guide that tells you >>these things? > > > We went through this years ago when going from 7.something to 9.21, I think. > Can not recall seeing anything in the release notes. It wasn't even mentioned > in the the list of reserved words in 9.21. I beleive it first appeared in the > the list of reserved words in 9.3. REF seems to have bitten a number of people - and one of them was sufficiently irate and had enough clout that a 10.00 fix pack will actually have the word REF (and DEREF) removed as key words (which is good since they aren't actually used anywhere). -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2005.01 -- http://dbi.perl.org/