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
busseb
9/23/2020
7:32:28 PM

What is the difference between
{RANKPRIME}
{RANKPSR}

Both show as supported factors for probability expressions.

Using HDW files.

Are they in the Starterhistory table or just the StartersToday?
What columns would they be?


Reply
jeff
9/24/2020
10:16:58 AM
Let's break this down one topic at a time.

--You asked:

"What is the difference between
{RANKPRIME}
{RANKPSR}"


--My reply:

There is no difference between the two.

If your StarterHistory table contains HDW data, "{RANKPRIME}" (without the quotes) or "{RANKPSR}" (without the quotes) both enable you to use rank for HDW PSR in a Prob Expression.

If your StarterHistory table contains Brisnet data, "{RANKPRIME}" (without the quotes) or "{RANKPSR}" (without the quotes) both enable you to use rank for Brisnet Prime Power in a Prob Expression.


--You also asked:

"Are they in the Starterhistory table or just the StartersToday?
What columns would they be?"


--My reply:

Neither Brisnet Prime Power or HDW PSR has its own column in the Table Schema.

But "PRIME" (without the quotes) is an available factor on the left hand side of Screen One in the SQL Factor Setup Tool.

If you are using HDW data, to add HDW PSR to your SQL Factor Setup:

Select "PRIME" (without the quotes) from the Available Factors List on the left hand side of Screen One in the SQL Factor Setup Tool.

Then assign it to one of the 35 F-Slots on the right hand side of Screen One in the SQL Factor Setup Tool - and hit the Save button.

If you are using Brisnet data, to add Brisent Prime Power to your SQL Factor Setup:

Select "PRIME" (without the quotes) from the Available Factors List on the left hand side of Screen One in the SQL Factor Setup Tool.

Then assign it to one of the 35 F-Slots on the right hand side of Screen One in the SQL Factor Setup Tool - and hit the Save button.



--You also asked:

"What columns would they be?"


--My reply:

It would be whatever column you assigned "PRIME" (without the quotes) to on Screen One in the SQL Factor Setup Tool.

Assume for the sake of argument that on Screen One in the SQL Factor Setup Tool you assigned "PRIME" (without the quotes) to F32.

If that's the case, correct syntax in a JCapper Prob Expression might look like this:

AND RANKF32 = {RANKPSR}

Alternately, you could use the following syntax:

AND RANKF32 = {RANKPRIME}

Both of the above would be correct and both would create the same factor handle for either HDW PSR or Brisnet Prime Power depending on whether you are using HDW data or Brisnet data.


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


-jp

.

Reply
Reply

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