>Hi Naomi,
> Ok, the problem is solved! This is very strange and I think it points to a bug in VFP.
>
> I issue an update:
> UPDATE MyTable SET MyColumn = MyValue WHERE MyColumn1 = MyValue
>
> If MyColumn1 is not a primary key, then the bad behavior occurs
> BUT
> If MyColumn1 is a primary key, then the bad behavior does not occur
>
> The "Bad Behavior" is: executing the table validation rule and, upon exiting the table validation rule, committing the changes.
>
> In my code, I was able to change "MyColumn1" to a primary key and that solved the problem.
>
> I believe this is a bug. I will report this.
> Thanks very much for your help!!
>
> Best regards, Chaim
I haven't have this situation before. I think you need to provide some repro.
If it's not broken, fix it until it is.
My Blog