Yes, I have both articles and am still testing with both the Oracle and MS drivers. I am trying with Long and Long Raw data types in the Oracle table.

>Hi!
>
>Did you tried the sample in the Q145991 and Q245714 MSDN articles? Try also another ODBC driver. I know we had several troubles that went away after we switched from Oracle to MS (or vise versa?) driver.
>
>
>>I read the FAQ and the KB articles referenced. The technique of parameterizing the general field in SQLExec to get it to Oracle is still failing. A search of entire MSDN on Oracle only turns up info on the VFP Upsizing wizard. :( Still trying though.
>>
>>>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