Duplicate/create Column - not valid SQL

Discuss how to create custom stats, reports and HUD profiles and share your creations.

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Duplicate/create Column - not valid SQL

Postby povva » Mon Jan 07, 2013 11:44 am

Hi, sorry if it's dumb questions, I've searched the topics, but didn't find an answer.

I have custom column for exampl.:

cnt_vpip_less_than_8bb

Expresion:
sum(if[(tourney_hand_summary.amt_p_effective_stack / tourney_blinds.amt_bb) < 8 AND tourney_hand_player_statistics.flg_vpip, 1, 0])

If I want to duplicate it and make for exampl.-
cnt_vpip_less_than_5bb
sum(if[(tourney_hand_summary.amt_p_effective_stack / tourney_blinds.amt_bb) < 5 AND tourney_hand_player_statistics.flg_vpip, 1, 0])

It shows me "not valid sql". What I'm doing wrong?
povva
 
Posts: 1
Joined: Fri May 18, 2012 7:51 am

Re: Duplicate/create Column - not valid SQL

Postby kraada » Mon Jan 07, 2013 12:59 pm

The first isn't valid either - amt_p_effective_stack is in tourney_hand_player_statistics, not tourney_summary - you probably got it there from importing an old stat from PT3 where it was in that location.

Changing it to tourney_hand_player_statistics.amt_p_effective_stack will fix your problems (and get that other stat to work properly as well).
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


Return to Custom Stats, Reports and HUD Profiles

Who is online

Users browsing this forum: No registered users and 37 guests

cron