Comparing Records

Christian_BuehlChristian_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_BuehlChristian_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)
Sign In or Register to comment.