Clarity

  • 1.  Carriage Return in a CLOB field?

    Posted Mar 05, 2009 07:11 AM
    I didnt know which sub-forum to stick this in so I went to the good ol GEL forum.     I have a "Large String" (CLOB) attribute that I am wanting to write to. It will serve as an audit of what has happened and populated by a process.     Update niku . ODF_CA_REQUISITION  Set itg_reqhistory = '03/3/09 Line 1'  Where ID = 5033003 ;     Commit;        Update niku . ODF_CA_REQUISITION  Set itg_reqhistory = itg_reqhistory || chr(10) || '03/3/09 Line 2'  Where ID = 5033003 ;        Commit;      I get the following when displayed in Clarity.   03/3/09 Line 1   03/3/09 Line 2     How can I get rid of that space before line 2? I have tried everything I could think of including trimming and taking off the first character with no luck. When I look at the actual HTML code of the text on the screen I see..     Requisition History 03/3/09 Line 1 > 03/3/09 Line 2  


  • 2.  Re: Carriage Return in a CLOB field?

    Posted Mar 05, 2009 09:44 AM
    Have you tried this?  Update niku . ODF_CA_REQUISITION  Set itg_reqhistory = itg_reqhistory ||'  '|| '03/3/09 Line 2'  Where ID = 5033003 ;   


  • 3.  Re: Carriage Return in a CLOB field?

    Posted Mar 05, 2009 09:50 AM
    That returns them both on the same line.  03/3/09 Line 1 03/3/09 Line 2


  • 4.  Re: Carriage Return in a CLOB field?

    Posted Mar 05, 2009 10:53 AM
    Sorry, I misinterpreted your question earlier. Try with below statement    Update niku . ODF_CA_REQUISITION  Set itg_reqhistory = itg_reqhistory || chr(13)||chr(10) || '03/3/09 Line 2'  Where ID = 5033003 ;      Message Edited by sivasairam on 03-05-2009 03:53 PM [left]