I am not quite sure what you are asking. You title says CursorAdapter so you can use the ConversionFunc property to RTRIM any character field data being sent back to the Oracle table --
Adapter.ConversionFunc = [LastName RTRIM, LastName RTRIM, etc]
If you are using SPT, your SQL could look like:
...SET LastName = ?RTRIM(crsCustomer.LastName), FirstName = ?RTRIM(crsCustomer.FirstName)
>Hello,
>
>can it be that this example only works because
>
>CURSORSETPROP("Wheretype",1) &&
>
>is Default?
>
>This Wheretype-option proves only the primary key and not the changed field. Update conflict is on Where-types 2 or 3:
>
>CURSORSETPROP("Wheretype",2) &&key and updatable fields
>CURSORSETPROP("Wheretype",3) &&key and modified fields
>
>I'm looking for solving the problem varchar in Oracle and Char in VFP. I have to trim the fields on Oracle before update with remote view or SPT-Cursor in VFP. If I use SQLEXEC(lnConn,"UPDATE....") I need the timestamp of record or old value the modified field. Oldval() and Curval() show always the same value.
>
>
>Have you got an answer?
>
>Claudia Przioda
Mark McCasland
Midlothian, TX USA