Database Handicapping Software- JCapper

JCapper Message Board

          JCapper 101
                      -- Question...

Home Register
Log In
By Question...
Caveat
1/6/2016
2:19:05 PM
I feel a little stupid asking this after 3 years but...

In SQL Mode can I use a factor thats not showing on the HTML Report as a UPR factor...
or does it need to be one of the 35

mike

take for example qrating

~Edited by: Caveat  on:  1/6/2016  at:  2:19:05 PM~

Reply
JackB
1/6/2016
8:38:33 PM
I have Qrating in the list of 48 factors. You can move it into those. Or make it a UserFactor and use it in the 35 factors that make up Fxx.

Be careful moving stuff around, You might have a UDM pulling that cell, thinking it is some other factor.

Jeff correct me if I'm wrong.



~Edited by: JackB  on:  1/6/2016  at:  8:38:33 PM~

Reply
Caveat
1/7/2016
7:50:02 AM
Thanks Jack....I fixed that

Now another...

Suppose I'm hand crafting a UPR ..
and I want to use a factor( say willtowin) and its not one of the 35 or showing up on the HTML report...

Can I use it in my UPR ?

mike

~Edited by: Caveat  on:  1/7/2016  at:  7:50:02 AM~

Reply
jeff
1/7/2016
8:42:59 AM

--quote:
"In SQL Mode can I use a factor thats not showing on the HTML Report as a UPR factor...
or does it need to be one of the 35

mike

take for example qrating"
--end quote


The short answer? Yes.

The longer answer? Here's how it works:

When creating entries in the IV Table Wizard or UPR Tools to define UserFactors and/or UPR:

Your sql factor setup and your html report layout do not come into play at all.

Simply put:

Any factor displayed in the factors drop downs of the IV Table Wizard or UPR Tools interfaces can be used in your entries to define UserFactors and/or UPR.




Q. So when does the sql factor setup come into play?

A. The sql factor setup comes into play for sql udms.

More specifically:

The sql expressions that make up your sql udm definitions are limited to the field names in the starterhistory table as defined in the table schema doc here:
http://www.jcapper.com/helpdocs/starterhistorytableschema.html





Q. When does the html report layout come into play - and what does it do?

A. The html report layout controls the location and display attributes of the factors shown on your html report.

As such it has nothing to do whatsoever with UserFactors, UPR, and/or SQL UDMs.


-jp

.


Reply
jeff
1/7/2016
8:43:55 AM

--quote:
"Now another...

Suppose I'm hand crafting a UPR ..
and I want to use a factor( say willtowin) and its not one of the 35 or showing up on the HTML report...

Can I use it in my UPR ?

mike"
--end quote


Yes. (See above.)


-jp

.

Reply
Caveat
1/7/2016
11:11:45 AM
:) thxs

Reply
Reply

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