>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 happen be updating the record using a primary key as the reference, I would validate that the index has not become corrupted. Try reindexing the indexes.
Also, check for partial string comparisions. VFP allows for example; 'ABCDEF'='ABC'. This can be cover come by either issuing SET EXACT ON before the update, or using the double equal sign; i.e. 'ABCDEF'=='ABC'. This would result in a False return where the previous may result in a True.
Greg Reichert