JCapper Message Board

JCapper 101
-- Rec Activity Days Last Start - SQL Mode

Home	Register Log In

Rec Activity Days Last Start - SQL Mode

jeff
2/28/2011
1:07:13 PM

--quote:

"Hi Jeff,
I am having a problem when makeing UMD's. When I query on some of the factor selections in the data window, I can not figure out how to write the (and) formulas for certain factors. Such as "Recent Activity-Days Last Start" . I've tried recent activity, days last etc and they are all invalid. I tried entering val and value to them but again no luck I went back about 7 pages on the site but no luck there."

--end quote

Goto JCapper.com and click the link labeled JCapper 101 Audio Video. You'll be taken to an index where different headings are listed. Click the index item labeled "Operating JCapper in SQL Mode." In the SQL Mode section, you'll find links to pretty much everything written and recorded about using JCapper in SQL Mode.

You want the Table Schema linked to here:
http://www.jcapper.com/helpdocs/starterhistorytableschema.html

The Table Schema lists out the field names and data types for all of the fields in the StarterHistory Table. In the case of Recent Activity Days Last Start, the field name in the table is "Racedays" (without the quote characters.) To add recent activity days last start to a sql expression, use a line like the following:

AND RACEDAYS < 120

No matter what factor you are using, using the exact field name as it is listed in the table schema will yield the best results.

Hope I managed to explain that in a way that makes sense,

-jp

.

JCapper Message Board

JCapper 101 -- Rec Activity Days Last Start - SQL Mode

JCapper 101
-- Rec Activity Days Last Start - SQL Mode