Can not edit the column

Forum for users that want to write their own custom queries against the PT database either via the Structured Query Language (SQL) or using the PT3 custom stats/reports interface.

Moderator: Moderators

Can not edit the column

Postby rebornok » Fri May 15, 2009 9:07 pm

if[ id_winner=0 , ((amt_won+amt_bet_p) / amt_c_1n) , if[ amt1>0 , ((amt_won+amt_bet_p) / amt_c_2n) , if[ amt1<0 , ((amt_won+amt_bet_p) / amt_c_3n) , 0 ] ] ]
Summery type = sum
If I try to change something in this expression, the dialog box with "Save Changes?" appears again and again untill I select "No".
I met this type of mistakes, but do not remember what could be wrong.
Can anybobody help, please?!
rebornok
 
Posts: 36
Joined: Sun Sep 14, 2008 6:30 pm

Re: Can not edit the column

Postby kraada » Sat May 16, 2009 9:33 am

Which section is this being created in? What are the definitions for the amt_c_1n amt1, amt_c_2n and amt_c_3n columns?
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Can not edit the column

Postby rebornok » Mon May 18, 2009 5:15 am

Section is Holdem Cash Hand.
amt_c_1n=2*(amt_bet_p+amt_2)+amt_rake;
amt_c_2n=2*(amt_bet_p+amt_rake+amt2)-amt_pot;
amt_c_3n=2*(amt_bet_p+amt2)+amt_pot;
amt_1=if[(holdem_hand_summary.cnt_players_f=2) AND (holdem_hand_player_statistics.flg_f_saw) AND (lookup_actions_p.action LIKE '%R') AND (holdem_hand_player_detail.flg_f_has_position), holdem_hand_player_statistics.amt_won,99999];
amt_2=if[(holdem_hand_summary.cnt_players_f=2) AND (holdem_hand_player_statistics.flg_f_saw) AND (lookup_actions_p.action LIKE '%R') AND NOT(holdem_hand_player_detail.flg_f_has_position), holdem_hand_player_statistics.amt_won,99999].
I need to change "amt1" to "amt2", i.e. change "1" to "2" twice in the main expression.
rebornok
 
Posts: 36
Joined: Sun Sep 14, 2008 6:30 pm

Re: Can not edit the column

Postby WhiteRider » Mon May 18, 2009 9:29 am

I think this is a known issue - I'll link this thread to the issue in our bug tracker and I hope it will be fixed for the next release.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Can not edit the column

Postby rebornok » Mon May 18, 2009 10:10 pm

Thank you!
rebornok
 
Posts: 36
Joined: Sun Sep 14, 2008 6:30 pm


Return to Custom Stats, Reports, and SQL [Read Only]

Who is online

Users browsing this forum: No registered users and 0 guests