Hi John ---

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