InstantForum.NET v4.1.4c360 Forumshttp://www.c360.com/Forums/support@c360.comSat, 22 Nov 2008 13:18:28 GMT20http://www.c360.com/Forums/Topic1845-10-1.aspxWhen you change the match code definitions and run Match Code Generation the results in the Potential Duplicates queue (i.e. View Potential Duplicates settings area) should reflect this change. If this does not occur then you will need to manually purge the database tables.</P><P>In order to do this you will need access to SQL. Just open a query window and paste the following statements:<BR><BR>USE c360_Solutions;<BR>TRUNCATE TABLE DupDet_Matchcode;<BR>TRUNCATE TABLE DupDet_PDQGeneration;</P><P>This will remove the content of both tables that Duplicate Detection uses. Next you will need to run Match Code Generation to populate these tables with data generated by the new match codes.<BR></P><P>-HenryThu, 25 Oct 2007 12:37:50 GMTHenryhttp://www.c360.com/Forums/Topic1845-10-1.aspxIs there a way to reset the current duplicate match results in the queue?</P><P>I would like to change the Match Codes and have all the old results go away.</P><P>ThanksWed, 24 Oct 2007 15:28:41 GMTAlan