>Hi Tom,
>
>>When I save a cursor with a large memo field, containing over 2000 characters, the 2000th character is often replaced with a chr(0). I may have seen this at the 1000th character as well, but I am not sure.
>
>Do you pass the content as a parameter or hard coded? If you hardcode the content, try a parameter instead. Sometimes changes the value for SYS(3055) also helps. If it's an update or insert statement you also might try to wrap it into an anonymous PL/SQL block:
>
>SQLEXEC(nHandle,"BEGIN UPDATE (....); END;")
>
Actually, I just have an updatable view, which contains the memo field. I stuff the data in it and do a TABLEUPDATE(). Nothing complicated at all. I always use a unique record key to update the table.
-- Tom.
Tom Green in Montreal