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