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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement