Re: Error 1279 ???

JO wrote: > When I run the script below (which was working) I get the error > "1279 value exceeds string column length". Finderr doesn't know > of this error number and I couldn't find it in the SQL error > messages book. Any insight on what the problem might be would be > appreciated. The cursor moves to the line "sfwork.sfstat < 3;" > when I run the script and get the error mesg. > > We are running SE 7.01 on an AlphaServer. 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. > database minx000; > create table woprj ( > wp_num CHAR (10), > start_date DATE, > due_date DATE, > pn_code CHAR (15), > pn_desc CHAR (35), > job_num CHAR (35), > job_desc CHAR (35), > prj_flag CHAR (35) > ); > insert into woprj (wp_num, start_date, due_date, pn_code, pn_desc, > job_num, job_desc) > select sfwo, sfedat, sfddat, sfwork.part, inpart.partdesc, > sfjob, pahead.padesc > from sfwork, inpart, outer pahead > where sfwork.part = inpart.part and > sfwork.sfjob = pahead.job and > sfwork.sfstat < 3; <======ERROR OCCURS HERE 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... -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v0.60 -- see http://www.perl.com/CPAN #include <disclaimer.h>