Database Handicapping Software- JCapper Screen One of the SQL Factor Setup Wizard - JCapper Help Doc
Last Updated: 05-08-2017
Add JRating - SQL Factor Setup Wizard - SCREEN ONE
In this Help Doc, I'm going to illustrate Screen One of the SQL Factor Setup Wizard and the process for adding JRating (or any supported JCapper Factor) to your SQL Factor Setup.

Of course, the ability to access JRating 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 Help Doc is the same for ALL of the supported factors that are not "native" to the StarterHistory table. So even if you are not JRating enabled, but want to learn how to modify your SQL Factor Setup and Custom SQL HTML Report Layout - read on.

IMPORTANT! Before going any further - and before performing any of the steps in this Help Doc: Make a Backup Copy of your c:\JCapper\Exe\JCapper2.mdb file.

This file contains your work.

Specifically: The c:\JCapper\Exe\JCapper2.mdb file is where the entries for your SQL Factor Setup, Custom SQL Mode HTML Report Layout, StarterHistory table, and WagerHistory table are stored.

If you value your work: You should be backing up this file on a regular basis. PCs and Laptops sometimes get stolen and hard drives can fail. Your work is the one thing I cannot replace.

I strongly recommend getting your backups onto other PCs and Laptops, CDs, Thumb Drives, and the cloud.

So before you perform any of the steps in this Help Doc: Make a backup copy of your c:\JCapper\Exe\JCapper2.mdb file right now!


That said, 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 the Factor Setup Tool button.

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