Database Handicapping Software- JCapper

JCapper Message Board

          JCapper 101
                      -- Probability Expression error

Home Register
Log In
By Probability Expression error
busseb
10/23/2016
5:12:28 PM
Tried to make the following Probability Expression:

SELECT TOP 600 * FROM STARTERHISTORY
WHERE TRACK = {TRACK}
AND DIST = {DIST}
AND INTSURFACE = {INTSURFACE}
AND RANKf06 = {RANKf06}
AND [DATE] < {TODAY}
ORDER BY [DATE] DESC

and couldn't save it because of an error. I pasted the JPR PE example in and only changed JPR to F06. I left everything else as is.

Any one smarter than I that can show me where my problem is?

Anyone have some good PE's that they would like to share with those of us struggling with the concept?



Reply
busseb
10/23/2016
5:36:23 PM
And another error:

SELECT TOP 100 * FROM STARTERHISTORY
WHERE TRACK = {TRACK}
AND DIST = {DIST}
AND INTSURFACE = {INTSURFACE}
AND rider = {rider}
and trainer = {trainer}
and railposition = {railposition}
AND [DATE] < {TODAY}
ORDER BY [DATE] DESC


Reply
busseb
10/23/2016
5:38:59 PM
And another one:

SELECT TOP 100 * FROM STARTERHISTORY
WHERE TRACK = {TRACK}
AND DIST = {DIST}
AND INTSURFACE = {INTSURFACE}
AND rider = {rider}
and trainer = {trainer}
and classdescriptor = {classdescriptor}
AND [DATE] < {TODAY}
ORDER BY [DATE] DESC


Reply
jeff
10/23/2016
6:44:55 PM

--quote:
"Tried to make the following Probability Expression:

SELECT TOP 600 * FROM STARTERHISTORY
WHERE TRACK = {TRACK}
AND DIST = {DIST}
AND INTSURFACE = {INTSURFACE}
AND RANKf06 = {RANKf06}
AND [DATE] < {TODAY}
ORDER BY [DATE] DESC

and couldn't save it because of an error. I pasted the JPR PE example in and only changed JPR to F06. I left everything else as is.

Any one smarter than I that can show me where my problem is?"
--end quote



--my reply:

The bolded part of the above expression text is causing the problem.

You're trying to use "RANKf06" (without the quotes) inside of the curly brackets.

But that doesn't work because "RANKf06" (without the quotes) isn't a supported factor handle.

Here's the rule: Any text in a Prob Expression that you use between the curly brackets MUST BE a supported factor handle.

Otherwise the interface gives you an error message that means: "Aint valid can't use that."

That's exactly what's happening here.

Here's a cut and paste of the Supported Factor Handles listed at the bottom of The Prob Expressions Help Doc:

--quote:
"
SUPPORTED FACTOR HANDLES FOR PROB EXPRESSIONS:
--Race level factors:
{TODAY}
{RACEDATE}
{TRACK}
{CLASSDESCRIPTOR}
{INTSURFACE}
{SURF_TYPE}
{DIST}
{DIST_TYPE}

{DISTANCE}
{FIELDSIZE}
{FTSCOUNT}
{PACEINDEX}
{PACEPRESSURE}
{ESPRACESHAPE}
{RACEVOLATILITY}

--Horse level factors:
{POS2CALL}
{POSFINCALL}
{DRIVETYPE}
{CANTRUNXFORMATTRIB}
{STAGEREADINESS}

{RAILPOSITION}
{RUNSTYLE}
{QSPEEDPOINTS}

{RANKEARLYCONSENSUS}
{RANKLATECONSENSUS}
{RANKCLASSCONSENSUS}
{RANKFIGCONSENSUS}
{RANKFORMCONSENSUS}

{RANKJPR}
{RANKJPRCLASS}
{RANKQRATING}
{RANKALCHEMY}
{RANKPRIME}
{RANKPSR}
{RANKMLINE}
{RANKPEDRATING}

{RANKCPACE}
{RANKV1}
{RANKCOMPOUNDAP}
{RANKCOMPOUNDSP}
{RANKCOMPOUNDLATE}
{RANKCOMPOUNDPACEFIT}

{RANKCFA}
{RANKOPTIMIZATION}

{RANKUSERFACTOR1}
{RANKUSERFACTOR2}
{RANKUSERFACTOR3}
{RANKUSERFACTOR4}
{RANKUSERFACTOR5}
{RANKUSERFACTOR6}
{RANKUSERFACTOR7}
{RANKUSERFACTOR8}

--Name based factors:
{RIDER}
{TRAINER}
{OWNER}

{SIRE}
{SIRESSIRE}
{DAM}
{DAMSSIRE}
"
--end quote





Now, all of that said...

If the factor that you have assigned to slot number F06 in your sql factor setup is on the above list of supported factor handles:

All you have to do to create the prob expression you were trying to create is replace "{RANKf06}" (witout the quotes) with the actual supported factor handle from the above list.

On the other hand - if the factor that you have assigned to slot number F06 in your sql factor setup is NOT on the above list of supported factor handles: You can't use that factor in a Prob Expression.

I hope I managed to type most of that out in a way that makes sense,


-jp

.











~Edited by: jeff  on:  10/23/2016  at:  6:44:55 PM~

Reply
busseb
10/23/2016
7:43:02 PM
Found a problem with my stuff:

I had checked the "Auto-Format" box.

When I un-checked the box, some of the above went through
the "save" and "calculate races".

Will work on the F06 problem.

Thanks!!

Reply
Reply

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