Memo width? Jerry -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of John Harvey Sent: Tuesday, April 17, 2012 12:42 PM To: 'ProFox Email List' Subject: RE: String too long to fit....
Change a data type? John Harvey -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Desmond Lloyd Sent: Tuesday, April 17, 2012 11:13 AM To: ProFox Email List Subject: String too long to fit.... Good Morning All, This piece of code has worked for ages. Now all of a sudden I am getting a "String too long to fit" error. Broke the union all into three different cursors, the first two are fine, the third errors out? Does anyone see anything blatantly wrong that would throw this error.... Regards, Desmond select womast01.step,stepcode.tbldesc as step_desc,womast01.sub_step,subCodes.tbldesc as sub_desc,000000 as sDays,womast01.wono,womast01.dept,womast01.item,womast01.engine,womast01.rec date,womast01.estdate as commit,womast01.location, ; womast01.descrip,arcust01.company,womast01.reqdate,date() - womast01.recdate as house_days,alltrim(complaint) as txt_comp,workreq,space(254) as wo_note from womast01,stepcode,subcodes,arcust01 where womast01.step = stepcode.code and womast01.sub_step = subcodes.code and ; womast01.custno = arcust01.custno and womast01.step = '22' and womast01.sub_step # '22' and womast01.status # 'H' into cursor hold1 *union all select womast01.step,stepcode.tbldesc as step_desc,womast01.sub_step,subCodes.tbldesc as sub_desc,000000 as sDays,womast01.wono,womast01.dept,womast01.item,womast01.engine,womast01.rec date,womast01.estdate as commit,womast01.location, ; womast01.descrip,arcust01.company,womast01.reqdate,date() - womast01.recdate as house_days,alltrim(complaint) as txt_comp,workreq ,space(254) as wo_note from womast01,stepcode,subcodes,arcust01 where womast01.step = stepcode.code and womast01.sub_step = subcodes.code and ; womast01.custno = arcust01.custno and womast01.sub_step = '22' and womast01.step # '22' and womast01.status # 'H' into cursor hold2 *union all >>>>>>>>> BLOWS U HERE <<<<<<<<<<<<< 8-( select womast01.step,stepcode.tbldesc as step_desc,womast01.sub_step,subCodes.tbldesc as sub_desc,000000 as sDays,womast01.wono,womast01.dept,womast01.item,womast01.engine,womast01.rec date,womast01.estdate as commit,womast01.location, ; womast01.descrip,arcust01.company,womast01.reqdate,date() - womast01.recdate as house_days,alltrim(complaint) as txt_comp,workreq,space(254) as wo_note from womast01,stepcode,subcodes,arcust01 where womast01.step = stepcode.code and womast01.sub_step = subcodes.code and ; womast01.custno = arcust01.custno and womast01.sub_step = '22' and womast01.step = '22' and womast01.status # 'H' into cursor hold3 [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/E6C2F3B85DD5464D9C9A45D51F3DEB1B@jerryfootePC ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
