Hi!

First of all, take a look to FAQ#7995. Its for SQl Server, however, there are references to MSDN articles for samples for Oracle with remote views.

As about ADO, binary data field in ADO have method AppendChunk that you can use to save data. To get data you require to use the ADO stream object, because GetChunk does not work in VFP.

HTH.

>I have tried this in VFP 6 and 7 using BLOB, LONG and LONG RAW on Oracle8 side. Then trying with Memo and Memo binary on VFP remote view. Also tried with SPT. And tried with Oracle and MS Oracle ODBC drivers. I can not get any combination to save the word doc back to the source table. I have not tried ADO yet.
>
>>Hi!
>>
>>Store it in a BLOB field. What tools you use for data accessing: Remote views, SQL Pass-Through or ADo recordsets? there are different approaches for each one with their own tricks. For the most popular and simple way, create the remote view, than opem view fields properties dialog box,select the BLOB field and change its type from general to memo. In the application you can store binary data from file into memo using FileToStr() function or append memo command. StrToFile() function or Copy Memo command will allow you to save data back into the file. Append memo is better because no additional memory used for strings produced by FileToStr().
>>
>>HTH.
>>
>>>Hi All,
>>>
>>> I would like to save World File (.DOC) in Oracle thru vfp. how can i store that? and also how to retrive in vfp from oracle daabase.
>>>
>>>regards
>>>
>>>amit