Hi Rick ---

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