Error when attempting to save new 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

Error when attempting to save new column

Postby Flip512 » Sun May 10, 2009 12:27 am

I just toiled over a new column, and when I tried to save it, it would continue to prompt me to save the column until I gave up and clicked cancel. I'm pretty new to the custom stats game, and am just starting to get a good feel for the language (haven't programmed a thing since my QBASIC class in high school). I found a way around the bug, but I wanted to post 1) to let you know about the bug, and/or 2) to figure out if the bug is really just me not understanding something.

Here are the details. I wanted to create a stat telling me what the average cbet of a player was as percentage of the pot. So I tried creating a column with this expression: sum(if[tourney_holdem_hand_player_statistics.flg_f_cbet, tourney_holdem_hand_player_detail.val_f_bet_made_pct, 0]) / cnt_f_cbet. It validated just fine, but when I tried to save it I started getting the prompt I mentioned. After trying to toggle some of the settings to no avail, I tried dropping the " / cnt_f_cbet" component, having realized I could add that in the actual statistic. After that it saved with no trouble. Was it a bug, or me being SQL-ignorant?

Also, another small question. With the val_f_bet_made_pct field: if a player bets, gets raised, and then 3bets; will the field return the value of just the first bet, just the 3bet, or the sum?

-Mike
Flip512
 
Posts: 28
Joined: Fri Jun 06, 2008 10:40 pm

Re: Error when attempting to save new column

Postby kraada » Sun May 10, 2009 9:39 am

I'm seeing that too and that shouldn't be happening. I'll make sure that gets looked at and fixed; I don't think that column should actually validate, and doing that sort of division will work much better in the statistic itself in any event.

With regards to val_f_bet_made_pct : that's the percent of the pot that your bet was, and it's specifically the first bet on the street. If you raised later on the street, you'd need to look at val_f_raise_made_pct (and if your raised twice, val_f_raise_made_2_pct).
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


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

Who is online

Users browsing this forum: No registered users and 0 guests