Come again? I'm not sure what a binary memo is and I'm not sure what part of the process you are referring to? Are you saying that I can convert the binary to memo text, save it to the oracle server and then when I need to download it, convert it back into binary, save as a file and then load it up as an OLE object? I hope so, it sounds like a much better solution.

Cheers, Pablo


>>Did you consider the alternative of saving the entire file into a binary >>memo, and copying back to disk on request?

>>Hilmar.

>When VFP saves a general field, does it include a wrapper or some class information along with the object???
>
>The problem we have is that my colleague is using a general field to get various different types of files (could be excel, could be pdf etc) into our oracle database. Fine so far. But now I am using ADO (+VFP or VB) to get the data back out again. I've had loads of problems getting either language to recognise the format of the data, so I saved the blob as a file. Even this didn't work, but when I looked closely at the start of each file in a text editor there was the fragment Visual FoxPro[Class] e.g. Visual FoxProExcel.Sheet.8.
>
>If VFP is putting a class wrapper around the document then that automatically makes the data proprietory to VFP, which kills my work stone dead.
>
>I've tried saving this data back into a general field and basing my OLE bound control on that but it doesn't really want to know....it doesn't crash but it doesn't work either...it just sits there in limbo sucking up memory.