How to find out that data was really changed?

[sinys]

I want to find out that data in record was really changed
With OracleDataSet1 do
begin
Edit;
FieldByName('id').AsInteger := 1; // old value = 1 and new value = 1
... // There are a lot of records where old value is equal new value
Post;
if Modified then ... // Modified = True, but it's not right actually
end;

Is there a property which can show changing data in record in fact? (If not, please add this property)

 

[Marco Kalter]

You will need to compare the Field.Value to the Field.OldValue for each field of the dataset.

 

[sinys]

But you write
>The OldValue property is only usable when cached updates is enabled.
inhttp://www.allroundautomations.com/...1&Main=9664&Words=sinys&Search=true#Post36440

 

[Marco Kalter]

Hmm. That was in a BeforePost event handler though. Are you using such a dataset even handler here?

 

[sinys]

Yes,
Example:

With OracleDataSet1 do
begin
Edit;
FieldByName('id').AsInteger := 1; // old value = 1 and new value = 1
Post; // -> GoTo BeforePost
end;

...
...BeforePost...
if Modified then
begin
FieldByName('date_change').AsDateTime := Now;
FieldByName('user_change').AsInteger := CurUser;
...
end;

 

[Andrey Maximenko. Ukraine]

...BeforePost...
if Modified then
begin
FieldByName('date_change').AsDateTime := Now;
FieldByName('user_change').AsInteger := CurUser;
...
end;

You have to move this code to trigger

 

[sinys]

You have to move this code to trigger

We do not use triggers.

 

[clivew]

We do not use triggers.

Then you need to consider changing your policy.
That is where it is easily and reliably done.
Otherwise, roll your own, you will have to store the original information on fetch and compare it before posting.
A lot more work and a lot less reliable.