Re: Error 1279 ???

Peter Lancashire wrote: > > JO wrote: > > > > Jonathan Leffler wrote in message <3660CD07.4A7C@earthlink.net>... > > >Are you sure? 7.10? I think 7.00 only ran on Sequents, and an > > >AlphaServer sounds like a DEC machine. And I don't think there > > >was a 7.01 anyway. > > > > Sorry, yes you are correct, it is 7.10 > > > > >Well, you might be using a MODE ANSI database, and one of the values > > >from the tables sfwork, inpart and pahead provides a value which is > > >too long to fit into the corresponding column of woprj. Or it might > > >be something else... > > > > Yes the db is now in ANSI mode. This happened last week when we upgraded > > our MRPII application to a newer version. Unfortuneatly I answered "YES" > > when I should've answered "NO" to "Create DB in ANSI Mode". Besides this > > problem, some of our Crystal reports no longer work either. Anyways thanks > > for the help. I've got a good idea of where and what to look for. > > > > Juergen > > > > >-- > > >Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) > > >Guardian of DBD::Informix v0.60 -- see http://www.perl.com/CPAN > > >#include <disclaimer.h> > > > > > In my (painful) experience, ANSI mode is to be avoided unless you really > (and I mean REALLY) need it. I agree Peter, but Jonathan likes ANSI mode and he does so much good in the Informix world that we allow him his eccentricities! ;-) Art S. Kagel