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.
Luc Nadeau
lnadeau@neova.ca"the theory, it is when all is known and that nothing works. The practice, it is when all works and that nobody knows why." - Albert Einstein (Nobel of physique 1921)