JCapper Message Board

JCapper 101
-- SQL Factor Abbreviations

Home	Register Log In

SQL Factor Abbreviations

joe_muller
9/8/2013
10:47:08 PM

Is there a location where I can get the SQL abbreviations for the factors in JCapper Platinum? For example, I can't figure out how to write SQL for Class Shift (Using Pars and Race Strength) limitation. I tend to take logical guesses at the abbreviations to use (other than "F" factors) and that takes too much time.

Thanks,
Joe M
Seattle

Charli125
9/9/2013
2:02:14 PM

Use this Joe, I use it all the time: http://www.jcapper.com/helpdocs/starterhistorytableschema.html

Here are the breakdowns for class shift:
clshift number integer class shift using purse value
clshift2 number integer class shift using par and race strength

So basically your SQL will look something like this clshift<=5

And welcome, glad to see another Seattle guy using Jcapper.

joe_muller
9/9/2013
7:07:21 PM

Thanks Charlie, glad to know I'm not the only web footed JCapper here. Am really enjoying using the program and thanks for pointing me to the help doc, it's going to help a lot.

Joe M
Seattle

JCapper Message Board

JCapper 101 -- SQL Factor Abbreviations

JCapper 101
-- SQL Factor Abbreviations