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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only