Database Handicapping Software- JCapper Add JRating - SQL Factor Setup Wizard - SCREEN ONE
April, 2012
Add JRating - SQL Factor Setup Wizard - SCREEN ONE
In this article, I'm going to illustrate Screen One of the SQL Factor Setup Wizard and the process for adding JRating to your SQL Factor Setup. Of course, the ability to access JRating (so that you can add it to the SQL Factor Setup) is restricted to the original 100 JCapper registered program owners only. If you are not JRating enabled, you can't access JRating as a factor and you can't add it to the SQL Factor Setup.

However, the procedure illustrated in this article is the same for ALL of the factors that are not "native" to the StarterHistory table. So even if you are not JRating enabled, but want to learn how to add other available factors to your SQL Factor Setup - read on.

Here are the steps for adding JRating (or any available factor) to the SQL Factor Setup:

1. Launch the SQL Factor Setup Wizard - On the face of the JCapper Main Module, click System Settings. Then, on the System Settings Interface, click System Definitions. This will launch the User Sys Defs Screen.

From here, to launch the SQL Factor Setup Wizard: click the SQL Factor Setup button located in the upper right area of the User Sys Defs Screen.

2. Add JRating (or another JCapper factor) to your SQL Factor Setup - Screen One of the SQL Factor Setup Wizard -screenshot click here- is an interface that gives you the ability to define the factor names for your SQL Factor Setup.

There are 35 user defined slot numbers - also known as SQL-F Slots on the right hand side of this screen. Each of the 35 slot numbers on the right hand side of this screen is customizable by the user. Each of these 35 slot numbers acts as a placeholder for a factor name. The 35 factor names persisted on the right hand side of this screen collectively ARE your SQL Factor Setup.

To add JRating (or another factor) as one of the 35 factors in your SQL Factor Setup:
  1. Highlight a slot number for factor removal: Click the slot number on the right side of the interface for the factor that you wish to remove.


  2. Remove a factor: With the selected slot number highlighted on the right side of the interface, click the Remove Factor button located in the center area of the interface. (This button is indicated with arrow like characters <<<------- that point away from the 35 SQL-F Slots.)

    Note that as soon as you click the Remove Factor button - You now have only 34 factors displayed on the right side of the interface. That's ok. We will be adding JRating (or another factor) to the right side of the interface in a moment.


  3. Highlight a factor to be added: Click the factor name on the left side of the interface for the factor that you wish to add (in this case JRating.)

    Note that as soon as you click a factor name on the left side of the interface, that factor name becomes highlighted.


  4. Add highlighted factor to right hand side of interface: With the new factor name highlighted on the left hand side of the interface, click the Add Factor button located in the center area of the interface. (This button is indicated with arrow like characters ------->>> that point towards the 35 SQL-F Slots on the right hand side of the interface.)

    Note: As soon as you click the Add Factor button, you will once again have 35 factors displayed on the right side of the interface. Also note that the newly added factor appears at the bottom of the right hand side of the interface (down in Slot #35.)


  5. Re-Order Factors on the Right Side of the Interface: The factor names on the right hand side of the interface can easily be re-ordered. To reorder or reposition an individual factor on the right side of the interface to a different slot number, click that factor to highlight it, and then click either the UP Arrow button or the DOWN Arrow button. Both buttons are located in the center area of the interface.

    Each single click of the UP Arrow button moves the selected/highlighted factor up one slot number. Likewise, each single click of the DOWN Arrow button moves a highlighted factor down one slot number.


  6. Save Your Work!: Once you are happy with the factor names and slot numbers that collectively define your SQL Factor Setup, click the SAVE button.


  7. Alternately, abandon Your Work. If you are unhappy with the factor names and slot numbers as they appear on the right side of the interface and you do not want to continue: DO NOT click the Save button.

    However, if you fail to click the Save button, any changes made to the SQL Factor Setup here using Screen One will not be available to you later after navigating to Screen Two.

    Clicking the RESET button instead will reset slot numbers and factor names back to where they were when you first launched this screen. Clicking the EXIT button without clicking the SAVE button (and answering No when prompted to save your work) will get you out of the SQL Factor Setup Wizard without saving your work.


  8. This Screenshot -click here- shows Screen One of the SQL Factor Setup Wizard with JRating added to Slot #29.


At this point, JRating (or another factor) has been added to the SQL Factor Setup (but not yet to the SQL HTML Report.) We are done with Screen One of the SQL Factor Setup Wizard and can move on to Screen Two of the SQL Factor Setup Wizard (where we will add JRating to the SQL HTML Report.) To navigate to Screen Two of the SQL Factor Setup Wizard, click NEXT.

NEXT... Adding JRating to the SQL HTML Report using SCREEN TWO --click here--

-jp

.

Copyright © 2008 JCapper Software              http://www.JCapper.com