|
JCapper Message Board JCapper 101
|
| Home |
Register
Log In |
| By | Rider Trainer Win Percent - SQL Mode | |
| jeff 5/26/2012 2:03:32 PM | --quote: "Is it possible to query inside the SQL data window a rider or trainer win percentage? I don't see a rider win percentage or trainer win percentage as a parameter or factor to query on in SQL. I assume you can do this in playlist mode with a filter but how do you do it in SQL?"--end quote Going through my spam folder this am with a cup of extra strength/highly caffeinated java from the coffee shop across the street in hand - and noticed your email from earlier in the week sitting in my spam folder. I'm not sure how or why it ended up there but apologies for not seeing it sooner... My reply to your question: Win percent for both rider and trainer are in the default sql factor setup - Provided you didn't change that and left them in your sql factor setup, it's a matter of breaking the Data Window query results out by the F-Slot number instead of the factor name. For example, if you want trainer win percent, and you happen to know that trainer win percent is assigned to F-Slot number XX, then select SQL-FXX from the Data Window factors drop down and execute your query. Hint: If you're not sure which slot number they are in, just hit the Display Factors button on the SQL Execute Tool to see your factor setup - and hit the button a second time to get back to normal display. You will likely need to set the start range and interval drop downs in order to see the breakout data. I'm not using win percent for either rider or trainer in my own factor setup - and I can't recall if the values for rider/trainer win percent are rendered in whole numbers (where 25 percent is displayed as 25.00) or in decimal format (where 25 percent is displayed as 0.25) - but by setting the start range and interval drop downs accordingly you will be able to make the Data Window display breakout data for rider/trainer win pct in an acceptable manner. -jp .
|
| Reply |
|
Copyright © 2018 JCapper Software back to the JCapper Message Board www.JCapper.com |