Yes you are right. I just don't understand why VFP would see this as an update conflict because you are only changing the value of the data being sent back to the table and not the current value in the table.

>Mark,
>
>Wouldn't the Trigger above reset whatever the new changes are back to what was in the table?
>
>Any way I did create triggers on the Oracle side. They were very similar to the one above with the one exception.
>
>

:new.VarCharField1 := rtrim(ltrim(:new.VarCharField1))

>
>The Problem with doing that was when issuing a tableupdate with a force value of .f. an error occured. The trigger changes the values of the table causing VFP to see this as a change by another user (since the trigger is executed by the server). Thus I get an error unless I set force to .t. and there are instances where business logic will not allow a force value of .t.
>
>I will keep digging. If you come across anything please let me know.
>
>Matt