PDA

View Full Version : Complatetly deleting hands



Episteme
08-10-2008, 10:23 PM
I want to completely delete one session of hands as well as the stats in HEM. The FAQ says:

Go to Options > Purge where you can delete hands based on game type, stakes, poker site and date.

This completely deletes the hands and stats from the database for good. There is also another option to purge hands where it only deletes the HH information but keeps the stats. Search "Purge Hands" for more information.


I have what I believe to be the latest version (1.06.01i) but in the options menu there is no option to purge. Again I want to get rid of the stats too, so going to Options > Observed Hand History Configuration Hand History Options doesn't help me much.

Thanks.

Episteme
08-11-2008, 05:33 AM
Found the hidden update ;-)

http://www.rvgsoftware.com/hm/hmupdate1.06.01s.exe

eyedol
08-12-2008, 07:34 AM
I have some stakes/limits that I want to delete. There is no handhistories for these (I think I deleted the hands by right clicking on them).

Tried the purge and delete all hands from this stakes but they stakes are still there..

morny
08-12-2008, 11:48 AM
http://208.109.95.123/faq/?f=107 This option deletes the HH but keeps the stats and looks like what you done

This ooption deletes the HH and the stats completely and is probably what your looking for: http://208.109.95.123/faq/?f=152

eyedol
08-12-2008, 11:54 AM
As I said I already tried that, the stakes are still selectable in the filters etc..

morny
08-12-2008, 06:32 PM
They will be still selectable in the filters if you have played that level but when you search that filter then they shouldnt show up anything. If they are showing up then make sure you using http://www.rvgsoftware.com/hm/hmupdate1.06.01t.exe and try a delete again and let us know how it goes.

eyedol
08-12-2008, 07:33 PM
Yes I understand this. Nothing shows up. I want to delete the stake so it's NOT selectable. It's really no point having a limit as 25/25 there (something bugged with a party HH).

Please advise how to do this.

eyedol
08-19-2008, 09:48 AM
Bumping this one. Any ideas? SQL-querys or whatever, just wanna get rid of some stakes.

Rvg72
08-20-2008, 01:15 AM
Bumping this one. Any ideas? SQL-querys or whatever, just wanna get rid of some stakes.

You could do it through SQL

Close HM and then load up pgadmin and go to a query window and type

select * from gametypes

you will see a big list - find the one that is 25/25 or whatever in the description and then type (changing 12345 to the real ID)

select * from gametypes where gametype_id = 12345

Once you confirm that this is the right one delete the select and change it to delete so that it says

delete * from gametypes where gametype_id = 12345

Using that trick where you do a select first and then change it to a delete has saved me many times.



Roy

eyedol
08-20-2008, 06:52 AM
Thanks Roy!

It worked but I had to change the last line to:

delete from gametypes where gametype_id = 12345

If I used "*" it did not work.