Re: Comparing RECORD's

: >From: root@candle.pha.pa.us (Bruce Momjian) : >Subject: Comparing RECORD's : >Date: Tue, 14 Jun 1994 04:05:20 GMT : >X-Informix-List-Id: <news.7206> : > : >If I have two structures with idenical fields, is there an easy way to : >see if the values in each of the fields is the same, without comparing : >each and every field (with NULL checks too)? : > : >I need this because I am using a INPUT ARRAY statement, but want to : >record the date each row changes. I am going to store the record in a : >BEFORE ROW statement, and compare in an AFTER ROW statement. : > : >Is there a better way to do this? I saw a posting earlier in this group that may have some utility in this situtation. What the poster had done is put another field in each table. The field held a checksum that was calculated on the values of each other field in that row. I believe it was activated by triggers. Hence, you could look at the checksums and see if two records were ***probably*** identical. For what it's worth.... -- =========================================================================== jlumbley@netcom.com (Joe Lumbley) BancTec Service Corportation 214-450-9896 Dallas, Texas Watch for my _INFORMIX DBA SURVIVAL GUIDE_ in Sept '94 from Prentice Hall! (Informix Press, ISBN 0-13-124314-1) ===========================================================================