by _dave_ » Tue Mar 18, 2008 11:16 pm
I can answer part 2:
[quoteogi]
2. In PT2 you could click on the top of a column you wanted to sort by and it would give you the SQL statement. Will you be able to do this in PT3? Mainly needed in the tourney window.[/quoteogi]
[listogi]
[*ogi]Do this - open up the pokertracker.log text file in "C:\program files\pokertracker 3" (or wherever you installed PT3)[/*:mogi]
[*ogi]Scroll to the end[/*:mogi]
[*ogi]Refresh the tab you are wondering what the SQL is on[/*:mogi]
[*ogi]Reload the log file (hopefully your text editor does this for you - I use PSPad) - stuff newly added contains the SQL executed by PT3[/*:mogi][/list:uogi]
Alternatively, enable logging of sql "All" on your PostgreSQL server, restart it, then study the log files it generates whenever you run certain reports.
Enjoy :)