Hi

I am using UPDATE SQL and INSERT SQL to maintain my tables. Is there any way to log changes of the fields i.e. before and after info, in these tables to a log file/table without doing the normal read and compare before the SQL statements ? If a read/seek has be done first, then I am effectively going to have to perform 2 read i/o's ie. one for the read/compare and one for the SQL statement. I feel it is quite inefficient and hope that there could be a better and more efficient way of doing this.

Any ideas/suggestions would be much appreciated.

Thanks in advance