>I'm using a FoxPro 9 front end via Oracle ODBC to Populate an Oracle table.
>The Oracle table has a field with CLOB data type.
>
>
>I'm using SQL passthrough to create a FoxPro cursor. The CLOB is mapped to a FoxPro Memo field.
>
>To populate the memo field, I use the FILETOSTR( DocumentName). Work fine in the FoxPro cursor.
>
>When using the TABLEUPDATE(), only part of the content of the MEMO field update the the CLOB ORACLE field.
>So when I retreive the field back, the document is damaged.
>If I try with plain text, everything works fine
>
>
>1) What is the best way to achieve my goal?
>2) What is the best Oracle data type to use to strore Word document?
>3) Do I need to use CONVERTBINARY(), if yes, how do I reconvert to character?
>4) Anyone with sample code to achieve this?
>
>Any hints would be appreciated.
Some ideas:
Store Word (.DOC) file in Oracle Thread #
546058 Message #
546058Re: MSWord VFP and Oracle 9i Thread #
892991 Message #
893001I respect the suggestions in the thread, but I would try Blob instead if you can. I think it is easier to work with.
.·*´¨)
.·`TCH
(..·*
010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"