From: Heran Q. <hq...@pu...> - 2011-10-06 06:26:32
|
Hi all, These days I change the way how result table view modifies data. Previously when two records are the same, for example: id var --------- 1 a 1 a 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 trouble. 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. Heran |