Rick ---

I don't have an Oracle manual here but what precisely is a LONG datatype?
And *was* comparememo true or did you now set it true?

>
>Compare Memo(Include memo fields in where clause) property is TRUE
>Again, thanks in advance for your help
>
>>OK, how about the view's CompareMemo property?
>>
>>>DataType on BackEnd is 'LONG' datatype. I chose this dataype b'cos it can hold more data than 'VARCHAR2'(max here is 2000)
>>>The field is tagged updatable using View designer
>>>There are no constraints or stored procedures associated with that field
>>>
>>>One more thing: The view has 'FETCH MEMO' option set as 'FALSE' to speed up the retrieval of the view
>>>
>>>>What is the datatype for that Memo on the backend (in Oracle)?
>>>>Has the field been tagged as Updateable using View Designer -or- DBSETPROP()?
>>>>Are there and constraints or stored procedures associated with that field
>>>>in Oracle?
>>>>
>>>>
>>>>>I have a remote view based on an Oracle table.
>>>>>The view has a memo field along with other types of fields.
>>>>>I buffer the view with optimistic (# 5) buffering and when I issue a tableupdate, all fields are saved back to Oracle table except the memo field.
>>>>>
>>>>>I tried so many times, but it does not seem to update.
>>>>>Please tell me what I am doing wrong.
>>>>>
>>>>>Thanks in advance