Database Handicapping Software- JCapper Screen One of the SQL Factor Setup Tool - JCapper Help Doc
Last Updated: 03-12-2021
Add JRating - SQL Factor Setup Tool - SCREEN ONE
In this Help Doc, I'm going to illustrate Screen One of the SQL Factor Setup Tool 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 Tool - 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 Tool -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 Tool without saving your work.


    8. This Screenshot -click here- shows Screen One of the SQL Factor Setup Tool 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 Tool and can move on to Screen Two of the SQL Factor Setup Tool (where we will add JRating to the SQL HTML Report.) To navigate to Screen Two of the SQL Factor Setup Tool, click NEXT.

IMPORTANT! Before going any further - be advised of the following:

After you hit the Save button and persist changes to your SQL Factor Setup, when you next run a SQL Calc Races or SQL Build Database routine:

The Interface will write data to your StartersToday and/or StarterHistory tables that reflects new changes made to your SQL Factor Setup.

HOWEVER: Changing your SQL Factor Setup does NOT (repeat NOT) change existing data in your StarterHistory table.

To see data that reflects changes to your SQL Factor Setup in the Data Window:

You'll need to rebuild database(s) from scratch. How many folders is up to you.

Run the DB Build routine on the very first folder in Mode 3.

Run DB Build routines for each subsequent folder (including your current quarterly folder) in Mode 4.

After you are all caught up and start to add new .JCP and .XRD files to you current quarterly folder you can run daily DB Builds on your current current quarterly in Mode 5 again.


NEXT... The Factor Reassignment Screen --click here--



-jp

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