>>>
>>>Then wouldn't just a simple IF (VARTYPE(OLDVAL(FIELD(i))<>VARTYPE(EVALUATE(FIELD(i))) be sufficient, or do you need to know when character (or other type) value changes, too?
>>
>>No, this would not work for me. The comparison should work on many different fields. Some fields will change the value but the type will be still be the same. The above expression will not pick up those cases.
>
>See FieldChanged function from the message link I gave you. (at the bottom of the message).
I will check the function although I am very careful not to make too many changes in the existing code. You see, the existing code worked except for the case of the old value being logical and new value being NULL. Once I added reversed comparison the code works (so far in my tests).
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
