These days I change the way how result table view modifies data.
Previously when two records are the same, for example:
and when we are going to remove the second record, the first one will
also be removed. In this patch I use ROWID and ORA_ROWSCN to identify
the record in order to prevent such problem. Also, when user modify data
many times, no history will be saved. And this history may cause some
In some databases like MySQL there is no rowid. In this case the old
change set will be used. I don't have MySQL and other database servers
so I'm not sure if they will work properly.
Currently this feature is with trotl because it is also a new feature. I
spent some time in this but I'm still not sure if this is the best way
to implement. Thanks for sharing your idea.