Fw: 617 error

I've found a bit more on this. It seems a work around would be to unload from one table and load into the other. Also, would the filetoblob be pretty much the same thing? TIA ----- Forwarded by Darren Jacobs/7001/Carmax on 03/16/2006 11:36 AM ----- Darren_Jacobs@car max.com Sent by: To informix-list-bou informix-list@iiug.org nces@iiug.org cc Subject 03/16/2006 11:23 617 error AM Greetings, I have a user that needs to insert a char into a text datatype. The following 617 error is being received. I've looked into cast's but not sure if it will work. The sql statement is below. I know I've seen chatter on this before but do not recall the solution. Any help would be greatly appreciated. 9.40 FC2w4 HPUX 11.11 Thanks -617 A TEXT or BYTE data type must be supplied within this context. This statement assigns a value that is not a simple large object to a BYTE or TEXT column or assigns a BYTE or TEXT column to a column that is not a simple large object. Neither action is supported. BYTE and TEXT values must be assigned as whole units to columns of the same type. Check that the statement specifies the columns that you intended. insert into ps_cx_age_cmnt (business_unit, cust_id, item, cx_comment_date, cx_oprid, comment_source, cx_caf_sup_review, cx_perm_message, cx_cmx_sup_review, cx_descrlong, cx_initials)select business_unit, cust_id, item, accounting_dt, "CARMAX", "C", " ", " ", " ", cx_comments, -- (This is the character field trying to insert into cx_descrlong, which is a text field) "N/A" from ps_cx_penditem where cx_comments <> ' '; _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list