>>Isn't adding a record is a change by itself?
>>
>
>No, not in our framework. In other words, I want to be able to distinguish between new and empty (no changes done to the record) and new and dirty (some changes were done). In my case I receive false positives because of iActive_Flag. It may be a MereMortals issue and we may need to somehow change the IsChanged method (it currently already ignores PK fields), but I'd like to also hear some suggestions outside the framework.
>
>>>I'm using a view. The table has iActive_Flag field with default value = 1. In my view I set the same default value for the iActive_Flag. Now, when I add a record, GetFldState function reports this field as changed and therefore even if I don't change anything I see a question asked: "Do you want to save your changes?".
>>>
>>>How can I solve this problem?
GetFldState(-1), first byte:
3 Field in an appended record has not been modified or deletion status has not changed for the appended record.
IF LEFT(GetFldState(-1),1) == [3] AND ;
NOT [4] $ SUBSTR(GetFldState(-1),2)
ENDIF
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.