Database Handicapping Software- JCapper

JCapper Message Board

          JCapper 101
                      -- SQL Search

Home Register
Log In
By SQL Search
rosenowsr
6/14/2020
8:38:44 AM
Jeff is it possible to make a udm in SQL(inside the jcapper program with out using excel) and not using factors in the factor list?

Could you give an example?

Reply
jeff
6/17/2020
12:09:20 PM
If by "the factors list" you mean The Key Factors Report in the Data Window, then the answer is yes.

If by "the factors list" you mean the column names in the Table Schema then the answer is no.

Link to the StarterHistory Table Schema - here:
http://www.jcapper.com/helpdocs/starterhistorytableschema.html

The rules are:

• Every column name that you reference in a sql udm or a sql expression that you execute in the Data Window must be an actual column name that exists in the StarterHistory table.

• Every column name in the Table Schema can be used in in a sql udm.

Example:

PRating is a factor that doesn't appear on the Key Factors Report.

PaceTop is also a factor that doesn't appear on the Key Factors Report.



But rankPRating, gapPRating, PRating, and PaceTop are each valid column names in the StarterHistory table (per the Table Schema.)

I could use PRating and PaceTop in a sql udm like this:

SELECT * FROM STARTERHISTORY WHERE RANKPRATING = 1
AND PACETOP = 0




-jp

.











Reply
Reply

Copyright 2018 JCapper Software              back to the JCapper Message Board              www.JCapper.com