Hi,
Sorry for unclear information.

I just have an experiement in the same pc.

E.g
I have 2 instance of VFP6. VFP-1, VFP-2
I issue the following statement in both instance in command window:

OPEN DATABASE mydb shared
USE mytable AGAIN SHARED ALIAS mytable1 (mytable2 in 2nd instance)
SET MULTILOCK ON
CURSORSETPROP("Buffering",5,"mytable1 (mytable2 in 2nd instance)")

Then, I update a record in VFP-1
UPDATE mytable1 SET myfield1 = "test"
?TABLEUPDATE(0,.F.) && RETURN .T.

Next, I go to VFP-2
?GetNextModified(0,"mytable2") && RETURN 0
?GetFldState(-1,"mytable2") && RETURN "11111"

If i use CURVAL or OLDVAL, both return correct value and I can know the changes, but It need to loop through all of the fields.


Any ideas?

thank you