Hiya Rick --

This one's a bear, huh? :-)

OK...try setting FetchMemo on, OK?
Also....take a look in the MS KB...I looked earlier but...who knows, I might have missed something....also...have you checked your checks and constraints on the Oracle side?



>
>VARCHAR2: Values of this datatype are variable length character strings of maximum length 2000. Oracle7 compares VARCHAR2 values using non-padded comparison semantics. The VARCHAR2 datatype is equivalent to the Oracle
>Version 6 CHAR datatype except for the difference in maximum lengths.
>
>LONG: The LONG datatype is just like a VARCHAR2 field. The maximum length a LONG value is now 2 gigabytes, increased from 65,535 bytes.
>
>I checked(TRUE) the Comparememo(Include memo fields in where clause) property in the 'Advanced options' menu of the view.
>
>Thanks
>
>
>
>>
>>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