>hi all , we've weird problem happening which we are having difficulty to trace. one of the fields in a table getting replaced with incorrectly with same field from different row.we are sure that it's not user changing this using any front end screen so It got to be a bug in the code. we use free tables so can't use any trigger to trap when it's getting modified. any suggestions/ideas to trap what program causing this ? thanks for the advise
If you use views, make sure the primary key is defined correctly. The "primary key" should define every record uniquely. Otherwise, changing a single record in the view may modify several records in the underlying table.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)