JCapper Message Board

          General Discussion
                      -- Revised HDW Chart File - CRC 10-12-2018

1. Make a backup of the following file:
   
   
   c:\JCapper\Exe\JCapper2.mdb
   
   This gives you an easy recovery path should something go wrong -- if for example you were to accidentally delete all records from your StarterHistory table in step 6 below -- or accidentally use mode 3 in step 10 below.
   
   --Hint: Be careful and don't do either!
   
   
2. Bring up the HDW File Mgr, click MENU, and run the IE/WinInet - Clear Cache menu item. This will clear your file download history and force the HDW File Mgr to deliver the most current version of all files during your next file download session.



3. Bring up the HDW File Download Tool, click the Queue Charts Files button. Scroll through the available chart files and click the CRC1012F.ZIP file to highlight it.
   
   
4. With the CRC1012F.ZIP file highlighted, click the DOWNLOAD button to save/overwrite the new file to your current active data folder. Then x-out of the HDW File Download Tool.



5. Bring up the File Build Filter Tool, type CRC into the track code textbox, select HDW Chart Results File (*F.*) from the file build type drop down, select 10-12-2018 as your start date from the calendar control, select 10-12-2018 as your end date from the calendar control -- and click the GO button to run an xrd file build for the newly downloaded CRC 10-12-2018 chart file.
   
   Close down the File Build Filter Tool and x-out of the HDW File Mgr.



6. Bring up the Data Window, click the SQL button, and paste or key the following sql expression into the sql expression textbox:
   
   
   

   DELETE * FROM STARTERHISTORY
              WHERE TRACK='CRC' 
              AND [DATE] = #10-12-2018#

   
   Click the Execute button and answer Yes at the prompt to delete all records for track CRC with [date] 10-12-2018 from your StarterHistory table.
   
   Allow the Data Window to do its thing and x-out of the Data Window after it gives you a confirmation message that records have been deleted.



7. Manually create a new folder on your hard drive. I named mine "_CRC10122018" (without the quotes) but you can use any valid folder name you want.



8. Using Windows Explorer, navigate to your current active data folder and find the files for CRC 10-12-2018. The specific files you are interested in are:
   
   
   CRC1012.JCP
   CRC1012.XRD
   CFC1012F.TXT
   
   
   Copy the above three files from your current active data folder to the new folder that you created in the previous step.



9. On the JCapper Main Module, click the Build Database button.



10. On the Database Builder, click the folder icon and use the folder Nav Tools to select the new folder that you created in step 7 (above.)
    
    Select Mode 4 as your Build Mode.
    
    Verify your folder, build mode, and file type --
    
    Then click the Build Database button at the bottom of the interface to run a Mode 4 build on the selected folder - which contains files for a single race card only: CRC 10-12-2018.

1. Make a backup of the following file:
   
   
   c:\JCapper\Exe\JCapper2.mdb
   
   This gives you an easy recovery path should something go wrong -- if for example you were to accidentally delete all records from your StarterHistory table in step 6 below -- or accidentally use mode 3 in step 10 below.
   
   --Hint: Be careful and don't do either!
   
   
2. Use a web browser to visit the HDW site.



3. Log into the HDW site.



4. Download the CRC1012F.ZIP file to your current active data folder.
   
   --Hint: You want to overwrite the previously downloaded (bad) version of the CRC1012F.ZIP file with the new current version file.



5. Bring up the File Build Filter Tool, type CRC into the track code textbox, select HDW Chart Results File (*F.*) from the file build type drop down, select 10-12-2018 as your start date from the calendar control, select 10-12-2018 as your end date from the calendar control -- and click the GO button to run an xrd file build for the newly downloaded CRC 10-12-2018 chart file.
   
   Close down the File Build Filter Tool and x-out of the HDW File Mgr.



6. Bring up the Data Window, click the SQL button, and paste or key the following sql expression into the sql expression textbox:
   
   
   

   DELETE * FROM STARTERHISTORY
              WHERE TRACK='CRC' 
              AND [DATE] = #10-12-2018#

   
   Click the Execute button and answer Yes at the prompt to delete all records for track CRC with [date] 10-12-2018 from your StarterHistory table.
   
   Allow the Data Window to do its thing and x-out of the Data Window after it gives you a confirmation message that records have been deleted.



7. Manually create a new folder on your hard drive. I named mine "_CRC10122018" (without the quotes) but you can use any valid folder name you want.



8. Using Windows Explorer, navigate to your current active data folder and find the files for CRC 10-12-2018. The specific files you are interested in are:
   
   
   CRC1012.JCP
   CRC1012.XRD
   CFC1012F.TXT
   
   
   Copy the above three files from your current active data folder to the new folder that you created in the previous step.



9. On the JCapper Main Module, click the Build Database button.



10. On the Database Builder, click the folder icon and use the folder Nav Tools to select the new folder that you created in step 7 (above.)
    
    Select Mode 4 as your Build Mode.
    
    Verify your folder, build mode, and file type --
    
    Then click the Build Database button at the bottom of the interface to run a Mode 4 build on the selected folder - which contains files for a single race card only: CRC 10-12-2018.

1. Make a backup of the following file:
   
   
   The pl_profile.txt file sitting on your current active data folder.
   
   This gives you an easy recovery path should something go wrong.
   
   
2. Use a web browser to visit the HDW site.



3. Log into the HDW site.



4. Download the CRC1012F.ZIP file to your current active data folder.
   
   --Hint: You want to overwrite the previously downloaded (bad) version of the CRC1012F.ZIP file with the new current version file.



5. Bring up the File Build Filter Tool, type CRC into the track code textbox, select HDW Chart Results File (*F.*) from the file build type drop down, select 10-12-2018 as your start date from the calendar control, select 10-12-2018 as your end date from the calendar control -- and click the GO button to run an xrd file build for the newly downloaded CRC 10-12-2018 chart file.
   
   Close down the File Build Filter Tool and x-out of the HDW File Mgr.



6. Whenever it's a convenient time to rebuild your current active data folder from scratch:
   
   On the JCapper Main Module, click the Build Database button.



7. On the Database Builder, select Mode 1 as your Build Mode.
   
   Verify your folder, build mode, and file type --
   
   Then click the Build Database button at the bottom of the interface to run a Mode 1 build on the selected folder (your current active data folder) which now contains the revised .xrd file for CRC 10-12-2018.
   
   Allow the Build Database routine to run to completion.