Database Handicapping Software- JCapper

JCapper Message Board

          JCapper 101
                      -- Some questions about sql mode?

Home Register
Log In
By Some questions about sql mode?
kingfish
8/7/2010
3:38:29 PM
If you run key factors report in sql mode. Do those factors listed in the key factor report populate the upr/userfactor tool? For example factors like basicfitness or rider win percentage. I know in playlist file mode all the key factors in the key factor report are available.

Also i searched for a sql expressions for dirt to turf. I seen sql expressions for ever other surface change.

kingfish

Reply
jeff
8/7/2010
4:35:03 PM

--quote:
"If you run key factors report in sql mode. Do those factors listed in the key factor report populate the upr/userfactor tool? For example factors like basicfitness or rider win percentage. I know in playlist file mode all the key factors in the key factor report are available."
--end quote



The KEY FACTORS REPORT in sql mode populates the the samplesummary table so that factor names sorted by either roi or iv appear in UPR Tools. The list of sql mode KEY FACTORS on the report is shorter than the playlist file mode list because the sql mode report is driven by your sql mode factor setup. The sql mode report displays only those factors that are either native to the table or found in your factor setup.



--quote:
"Also i searched for a sql expressions for dirt to turf. I seen sql expressions for ever other surface change."
--end quote



You'll find an explanation of how to do surface shift in sql mode in this thread:
http://www.jcapper.com/messageboard/TopicReader.asp?topic=646&forum=JCapper%20101


-jp

.



Reply
jager fury
8/9/2010
11:12:23 AM

--quote:
"The KEY FACTORS REPORT in sql mode populates the the samplesummary table so that factor names sorted by either roi or iv appear in UPR Tools. The list of sql mode KEY FACTORS on the report is shorter than the playlist file mode list because the sql mode report is driven by your sql mode factor setup. The sql mode report displays only those factors that are either native to the table or found in your factor setup."
--end quote


Which self help documents discuss the UPR Tools?

thanks

Reply
jeff
8/9/2010
2:12:23 PM
I bumped one of the threads in the private section where you can find links to videos of UPR Tools in use:
UPR Tools Info

Note: You have to be logged in to be able to view that thread.


-jp

.

Reply
Reply

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