|| Extreme pace races
|Does anyone have an idea on how to pick up horses who have come out of extreme pace (fast or slow) races in a sql expression. I don't understand gap relating to the factors I simply use rankF? in all my udms.|
"Does anyone have an idea on how to pick up horses who have come out of extreme pace (fast or slow) races in a sql expression?"
The factor in the program designed to give you a numeric handle on "pace (fast or slow) races" is FastSlowPace.
Before you can use it in a sql expression FastSlowPace needs to be part of your sql factor setup. To that end, here's a link to a 4 part web tutorial on editing the sql factor setup:
Once FastSlowPace has been assigned to a slot number you can use it in a sql expression by referencing the slot number it was assigned to.
In my own sql factor setup, FastSlowPace is assigned to slot number F06 - and I can use it in a sql expression as illustrated in the examples posted below:
AND RANKF06 <= 3
In the above expression I am requiring that rank for FastSlowPace be less than or equal to 3.
AND GAPF06 >= -7.5
In the above expression I am requiring that gap for FastSlowPace be within 7.5 points of the top FastSlowPace in the race.
FYI, you asked about gap. Gap for any factor is simply the difference in points between numeric value for the horse being evaluated and numeric value for the horse with the highest numeric value in the race.
Example: If Horse A has a numeric value of 72.5 and Horse B has the high score in the race for that same factor with numeric value of 80, then gap for Horse A is -7.5 (which can be calculated by subtracting 80 from 72.5) and gap for Horse B is 7.5 (which can be calculated by subtracting 72.5 from 80.)
AND VALF06 >= 77.5
In the above expression I an requiring that numeric value for FastSlowPace be greater than or equal to 77.5.
|Thanks for the help Jeff. Jcapper really is an amazing program and your support is unbelievable. One more question about gap. How would I write an expression that would only give me horses with at least 7.5 point advantage over the rest of the field in a given factor? Would it be AND GAPF06 >= 7.5|
~Edited by: bartsharkattack on: 10/17/2014 at: 2:40:04 PM~
~Edited by: bartsharkattack on: 10/17/2014 at: 2:44:39 PM~
~Edited by: bartsharkattack on: 10/17/2014 at: 2:45:32 PM~
|You nailed it.|
AND GAPF06 >= 7.5
The above line of sql will cause an existing expression to limit starters returned to only those with a gap in factor F06 of 7.5 or more.
Or put another way, the above line of sql will cause an existing expression to limit starters returned to only those with an advantage of 7.5 or more points of whatever factor is assigned to slot #F06 in your sql factor setup.