JCapper Message Board

JCapper 101
-- Probability Expression Error

Home	Register Log In

Probability Expression Error

NYMike
9/27/2024
6:47:52 AM

I keep getting the same response 0.00 (1) for every horse, even trying one right out of the help doc using behavior 18

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

Any ideas on why I am not getting a response?

Thanks,

Mike

NYMike
9/27/2024
6:57:23 AM

And this is containerless, just running a Calc to test, no database rebuild

jeff
10/26/2024
4:23:14 PM

Sorry I missed seeing this, Mike.

Do you still need help with this?

If so, shoot me an email.

-jp
.

jeff
10/28/2024
6:25:10 PM

The Prob Expression you posted looks right. Behavior 18 WinPct is certainly valid.

Provided you have a populated StarterHistory table my first best guess would be something along the lines of the Prob Expression was successfully added to an F-Slot Number on the right side of the interface on Screen One of the SQL Factor Setup Tool.

But maybe the original factor is still sitting in the same F-Slot number on Screens Two, Three, and Four of the SQL Factor Setup Tool (or something similar.)

Working on a step by step writeup with screenshots.

May take me a day or two to get that done. (It's essentially an addendum to the Prob Expressions Help Doc with more detail than the Prob Expressions Help Doc currently has for the Factor Setup Tool.)

-jp
.

jeff
10/30/2024
8:24:50 AM

Ended up making a series of videos.

They're rough and unedited (and are in dire need of editing in a few places.) Free time constraints prevent me from doing that.

But they show how to implement a containerless Prob Expression.

So I'm just going to post them.

Part 1

Part 2

Part 3

Part 4

Part 5

-jp
.

JCapper Message Board

JCapper 101 -- Probability Expression Error

JCapper 101
-- Probability Expression Error