JCapper Message Board

JCapper 101
-- Distance Shift in SQL Mode

Home	Register Log In

Distance Shift in SQL Mode

jeff
2/27/2010
12:54:43 PM

--quote:

"Hello, is there any thread, on how to make a udm for distance shift in SQL Mode? I know i could look it up on my HTML report under distance shift but i would like to have it shown in a udm, under Sprint/Route Route/sprint so will be easy to see it.

In playlist file mode we have preset filters S2R and R2S. Can't seem to find similar in SQL mode.

Any suggestions?"

--end quote

Go to JCapper.com and click the JCapper 101 Audio/Video link. In the index section, click the index item labeled Operating JCapper in SQL Mode. In the SQL Mode section, click the link to the Table Schema.

There are two fields in the table schema that can be used to control race distance:


Field Name		Data Type	Description
---------------------   -------------   ----------------------------------------------
dist			number single	distance in yards today’s race
distlastout		number single	distance in yards most recent start

Keep in mind that race distance referenced by both fields is distance in yards... 220 yds to a furlong... 1 mile = 8f... or 1 mile = 1760 yds.

To make a sql udm flag horses that are sprint to route, use the following two lines:

AND DIST >= 1760
AND DISTLASTOUT < 1760

To make a sql udm flag horses that are route to sprint, use the following two lines:

AND DIST < 1760
AND DISTLASTOUT >= 1760

-jp

.

ADAnto
2/27/2010
5:15:11 PM

Jeff, Got it!

Thank You.

Tony

JCapper Message Board

JCapper 101 -- Distance Shift in SQL Mode

JCapper 101
-- Distance Shift in SQL Mode