change fields in OnApplyUpdates => 'Record has been changed'

[icegood]

Tried to implement next architecture:
1) Generate fake id's on AfterInsert statement
MyDS.FieldByName('MY_ID').AsInteger := nFakeID;
2) Change them to real ones on OnApplyUpdates:
MyDS.FieldByName('MY_ID').AsInteger := nRealID;
Applied => FALSE to let DOA do rest of the work
=>
Record successfully saved

Now after ApplyUpdates and CommitUpdates and after trying to edit new inserterd record i've obtained :
'Record has been changed' on that field 'MY_ID'

How to overcome it?

Delphi XE3+DOA 4.1

 

[Marco Kalter]

Can you let me know the SQL statement for the dataset that raised this exception?

 

[icegood]

SELECT
ROWID,

FROM
MY_TABLE

 

[icegood]

And yes, lock model = lmLockImmediate

 

[icegood]

I must also say, that fields are created not only from SQL
There is also one more calculated field added...

 

[Marco Kalter]

Is there perhaps a before insert trigger that modifies one or more column values?

 

[icegood]

I obtained inconsistency on 'MY_ID' field and it's not changed on triggers

 

[icegood]

Please, consider attach to see what i mean.
1) Install your own session
2) compile and run under XE3
3) insert record.
4) apply updates. Note, that 'id' field on screen is not changed.
5) try to edit that new record => 'Record has been changed' error occurs.
https://drive.google.com/file/d/0B4mLkzBXmYycQ0V1d0wzdnlmSEE/view?usp=sharing