Comparing Records

Christian_Buehl
Christian_Buehl Member Posts: 145
edited 2002-09-24 in Navision Financials
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.

Comments

  • Christian_Buehl
    Christian_Buehl Member Posts: 145
    I found out a simple solution by myself:
    The Code
    if format(Rec1) = format(Rec2) then ...
    is workong fine (even on my old Finacials 2.01 Version)

Categories