Hi Mark and Paul,
I have been working on this problem for a few days now. I think what I am going to do is use sqlexec() to send an update command to my Oracle database. The reason is if you update the key field then foxpro will not update the oracle table. You can tell this if the record is deleted in you view.
>The only way I see it working is if the length of the value is always the same as the width of the field. The problem arises in that spaces are added to pad the width to match the width of the field. When VFP updates, it will compare "123" [VFP side] to "123 " [Oracle side] and get FALSE [returns an update conflict error]. So as long as all values are the same width as the field, updates will fail. This defeats the purpose of a varchar field.
>
>>Hi Mark,
>>
>>Thanks for your reply.
>>
>>Will this option work if the key field is a varchar2?
>>
>>Paul
>>
>>>
>>>I prefer the option to change the remote view update type to Key Fields only in order to avoid this problem.
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