Re: Error 1279 ???

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. -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 -- If all else fails, read the instructions and the release notes. Join Infuse, the UK Informix User Group at http://www.infuse.org.uk/