Does anyone know how a simple way to compare two records of a table.
Or is there no other whay than to compare each field?
Background: I want to record each modifications in a table (which is done in the OnModify-Section of the table) with the userid and date. But there are two special fields in this table. If there are only changes in one or both of this to fields I don't want to record this. My simple approach was to copy the Record and the xRec into a temporary table, to delete this fields in both tables and then compare the two records. But "if tmprec1 = tmprec2)" does not work.
0
Comments
The Code
if format(Rec1) = format(Rec2) then ...
is workong fine (even on my old Finacials 2.01 Version)