Error 1279 ???
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.
Thanks,
Juergen
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; <======ERROROCCURS HERE
insert into woprj (wp_num, start_date, due_date, job_num, job_desc,
prj_flag)
select job, pardat, pacdat, job, padesc, 'P'
from pahead
where pahead.paddat = DATE ('00/1/1') and
pahead.pacap <> 'S';
unload to '/minx/reports/wolist.exp' delimiter '|'
select * from woprj
order by wp_num;
drop table woprj;