JCapper Message Board

JCapper 101
-- off track UDM

Home	Register Log In

off track UDM

chrisl
4/12/2012
12:41:27 PM

I need some help on creating a sloppy/muddy/offtrack udm. I have looked for a help doc or video. I run in SQL mode. Thanks ChrisL

jeff
4/13/2012
10:51:15 AM

There are two steps involved:

1. Create a UDM that uses a specific track condition.

Here's a sql expression for a sample UDM:

SELECT * FROM STARTERHISTORY WHERE TRACK='AQU'
	   AND INTSURFACE <= 3                      
           AND TKCOND='MY'           
           AND RANKJPR=1

Note: The field in the table that corresponds to track condition is the tkcond field. The above sql expression finds JPR rank=1 horses on all dirt surfaces at AQU when track condition is MY.

2. In the Manual Changes Module, set track condition for at least one of today's races at the track from the UDM to match the tkcond field requirement defined in the UDM.

From there, when you run a sql calc races the UDM should "fire" when it encounters horses on the race(s) where track condition has been redefined in the Manual Changes Module to match the track condition defined in the UDM.

-jp

.

chrisl
4/13/2012
7:19:57 PM

Thanks Jeff...Chris

JCapper Message Board

JCapper 101 -- off track UDM

JCapper 101
-- off track UDM