Is it possible to eliminate duplicate hands?

[cubillas]

Hi Patvs!

I'm using a Database where some of my tournaments got duplicates hands, so when I go to the reports and click on a tournament all hands show me up twice. The most common solution for this is to create a new DB and re-import, but the problem is that by doing that i loose all the editions that i had to make to the tournaments buy-in's etc.
As you can imagine, with a DB f 3K tournaments that's almost imposible. Is there any solution more...traditional, like "select"---"delete" ? ( ahaha that would be nice)

Cheers

[Patvs]

Duplicate hands showing up in HoldemManager are a sign of a corrupt database.
So you'll have to create a new database, reimport the hands.

Since you edited many tournament results.
Go to tourney--> results--> dataview-->
set the date filter to ALL hands, so it will display ALL tournies.
Right-click on ALL tournies and select EXPORT tourney RESULTS and summaries

Next in the NEW empty database. First import the handhistories.
Then import the exported file from your previous database and it should update it with all the edits you made.