PDA

View Full Version : sql open specification



lusop
01-24-2011, 10:44 AM
Hi there,

Can I ask why there's not a open specification of the database schema? I really can't think about any reason and it would be really helpful for people creating their own sql reports.

Thanks

netsrak
01-24-2011, 01:21 PM
You should find some parts of it in this area Custom Reports - Holdem Manager Forums (http://forums.holdemmanager.com/custom-reports/)

but so far we haven't published a complete database scheme.

lusop
01-24-2011, 01:27 PM
Thanks for the reply. It should be useful, but you didn't answer my question.

Why there's not such a thing like a compete sql reference?

Many thanks

fraac
11-17-2011, 02:47 PM
Hi. Is the SQL spec for HEM1 available yet? Would be very useful. Cheers.

netsrak
11-18-2011, 06:37 AM
This is internal information which will not be published.
What you can do is enable SQL logging and see how statements work:
Close down HM and open the holdemmanager.config with notepad and change
<setting name="LogDatabaseCommands">False
To
<setting name="LogDatabaseCommands">True

Now run the report and when it finishes look in the logs folder for a file named dbtrace.log and open it with Wordpad and go to the bottom of the file and you will see the query.