On fox side data type is char and on Oracle side data type is varchar.
I already find a solution,the problem is that Fox will paddle the field to a fixed length, while Oracle is expecting trimed(varchar)variable. The solution is to map field type on foxside to memo
The MS knowledgy base artticla is NO:Q170129
>What is the datatype in the view and what is the data type on the Oracle side?
>
>
>>Thank you for your response.
>>But in my case, the field I was tring to update is not a key field.
>>
>>I can update the table through SQL passthrough
>>
>>>Qun ---
>>>
>>>That would occur if you were trying to update a key field where the key is generated by a sequence or stored procedure on the Oracle side.
>>>
>>>
>>>
>>>>Hi,
>>>>I created a remote view based on an Oracle Database. bt when I tried to update the a field I got a error message saying "Update Conflict".
>>>>
>>>>Basically, the view is not updatable.
>>>>
>>>>All the necessary setting has been checked such as writable, send sql update.
>>>>
>>>>Does anyone have any ideal?
>>>>
>>>>Qun Shen
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