|
JCapper Message Board JCapper 101
|
| Home |
Register
Log In |
| By | Been out of the loop for awhile... Couple questions | |
| notchback 10/26/2010 2:11:16 AM | I've been out of the loop for about a year. Just all the updates loaded and data bases rebuilt (from scratch) over the last few days. I am having some trouble with a couple of things and scratching my head. Maybe I am just rusty :-) I've read through the help docs and watched all the available videos and followed along with the examples... 1. Starter History Table. I get no results on a SQL data table query. I've ran the export and clear, then a full database query and all I get are 0's. Not sure what I am missing. 2. I keep getting the "there is a new JCapper.mdb" message when I run calc races or data base builds or the impact value table. 3. I get a "cannot initialize data bindings" and a "runtime error 9" message when I try to use any of the 'table' functions in the sys def screen. 4. I don't see any of my UDM's in the SQK expression mode (dunno what it's called.. the screen you enter SQL info) I think that sums up the issues I am having. Hope I explained it well enough. Thanks, Doug
| |
| jeff 10/26/2010 1:38:56 PM | Let's start here with "cannot initialize data bindings." Have a look at this thread in the Downloads and Tech Support forum: http://www.jcapper.com/MessageBoard/TopicReader.asp?topic=804&forum=Downloads Hint: You'll need to be logged in to read it. More to come... -jp .
| |
| jeff 10/26/2010 2:54:34 PM | --quote: "2. I keep getting the "there is a new JCapper.mdb" message when I run calc races or data base builds or the impact value table."--end quote You'll need to import the new table fields for using min and max field size in UPR Tools that were relased with the 10/23/2009 new program version. Scroll down to the post I made on 10/24/2009 in this thread about the 10/23/2009 new program update: http://www.jcapper.com/MessageBoard/TopicReader.asp?topic=554&forum=Downloads more to come... -jp .
| |
| jeff 10/26/2010 3:00:23 PM | --quote: "4. I don't see any of my UDM's in the SQK expression mode (dunno what it's called.. the screen you enter SQL info)"--end quote Have you created any sql UDMs yet? If so (unless you swapped out the c:\2004\JCapper.mdb file as part of your install) they should be visible in the Data Window's SQL Expression Tool. If you haven't created any sql UDMs then you wouldn't see any UDMs in the Data Window's SQL Expression Tool - as the software is programmed to display sql UDMs only and not playlist file UDMs when executing UDM queries when the Data Window is in sql mode. -jp .
| |
| jeff 10/26/2010 4:46:21 PM | --quote: "1. Starter History Table. I get no results on a SQL data table query. I've ran the export and clear, then a full database query and all I get are 0's. Not sure what I am missing."--end quote In General My first best guess is that the StarterHistory Table really hasn’t been populated. It doesn’t matter why. If you can’t see starter history data in the Data Window then you need to populate the table. Because it’s been a while since your last program install, it’s important to make sure that you have a current version JCapper2.mdb file sitting on your c:\JCapper\Exe folder. There is a checkbox on the face of the Installer labeled “Overwrite JCapper2.mdb.” I recommend that users get in the habit of always checking this box as part of each install. When this box is checked the Installer will rename your old c:\JCapper\Exe\JCapper2.mdb file from c:\JCapper\Exe\JCapper2.mdb to c:\JCapper\Exe\JCapper2_todaysDate.mdb and then copy a fresh blank current version coy of the JCapper2.mdb file on the c:\JCapper\Exe\ folder. Importing Old Data Into the JCapper2.mdb File After the install, you can go into the User Sys Defs Screen and click the JCapper2 Import button. When the Import Module comes up, check the boxes for those items you wish to import, select c:\JCapper\Exe\JCapper2.mdb as the Target File, select c:\JCapper\Exe\JCapper2_todaysDate.mdb as the Source File, and click the “GO” button to import data from the old/source file into the new/target file. Note: Importing old starter history data will populate the StarterHistory Table with old data only. This does not give you the ability to see the effect of any new JCapper factors added since the last time you updated the program. Populating The StarterHistory Table using Build Database Routines If it’s been some time since you last updated the program - It is a very good idea – very like required – that you rebuild databases from scratch. This is how you get new JCapper factors added since the last time you updated the program into your databases. If you use Build Mode 3, your Build Database routines will rebuild your pl_profile.txt file from scratch and clear and repopulate the StarterHistory Table in your c:\JCapper\Exe\JCapper2.mdb file with current program version JCapper data. Note: Read up on Database Build Modes here in the Building JCapper Databases Help Doc: http://www.jcapper.com/helpDocs/JCapper_BuildDatabaseHowTo.htm Populating the StarterHistory Table using Data Window Export Alternately, you can populate the StarterHistory Table using Data Window Export after rebuilding databases from scratch using Build Mode 1. Here are the steps: 1. Rebuild all databases from Scratch using Build Mode 1. 2. Put the Data Window in Playlist File Mode. 3. Point the Data Window at your (first/oldest) target folder. 4. CLEAR the StarterHistory Table. In the Data Window, click MENU, select Exports, and then select StarterHistory Table Export Clear First and answer yes at the prompts. This will clear the StarterHistory table and toggle an export "on" - meaning that the next query you run will, in addition to displaying results, write data for all starters returned by the query to the StarterHistory Table. 5. Run an ALL Button Data Window query. 6. Run a Compact and Repair Database routine on the c:\JCapper\Exe\JCapper2.mdb File. 7. Point the Data Window at your next target folder. 8. Click MENU, select Exports, and then and then select StarterHistory Table Export Append and answer yes at the prompts. This will toggle an export "on" without clearing the table - meaning that the next query you run will, in addition to displaying results, append data for all starters returned by the query to the StarterHistory Table - leaving you with a table populated with data from multiple folders. 9. Run a Compact and Repair Database routine on the c:\JCapper\Exe\JCapper2.mdb File. Repeat steps 7, 8, and 9 as needed until all of your target folders have been processed. Recommended Best Practices Although the StarterHistory Table can be populated by either running Build Database in Mode 3 or by running Data Window Exports, my thinking is most users should find it (initially at least) easier to Build Datbases in Mode 3 simply because it reduces the possibility of the user introducing human error into the process. It's also important that you get a current program version of the JCapper2.mdb file by clicking the Overwrite JCapper2.mdb button on the face of the Installer prior to running a Perform JCapper Install. -jp .
| |
| notchback 10/26/2010 5:44:49 PM | I don't see the 10/23 download on the download page?
| |
| jeff 10/26/2010 8:26:13 PM | Here's the link to the thread again: http://www.jcapper.com/MessageBoard/TopicReader.asp?topic=554&forum=Downloads Scroll about half way down. Here's a link to a screenshot of the post itself: Screenshot of my post on 10/24/2009 about the 10/23/2009 new program update -jp .
| |
| notchback 10/27/2010 12:26:21 AM | Thanks Jeff. I will work through it. Sorry for the trouble...
| |
| notchback 10/27/2010 1:45:36 AM | --quote: "1. Starter History Table. I get no results on a SQL data table query. I've ran the export and clear, then a full database query and all I get are 0's. Not sure what I am missing.--end quote OK... I have worked through all the issues (thank you!) sans, one... I still get all 0's on my SQL execution. I have rebuilt my data bases. I have followed the steps for populating the starter table. I have copied the SQL_Test UDM from the video exaclty as it was shown. I even did another database build (mode 3) with a handfull of files in a test folder. Nothing. I'm not sure what I am doing wrong. I am following along with the video step-by-step and still get 0's. Curiously, when I ran the JCapper2 Import routine, a message popped up telling me that some 54k starter history records were imported and the progress bar took quite some time cycling through as it was doing it. Obviously the records are getting written. Thanks for the help! Doug
| |
| jeff 10/27/2010 11:20:41 AM | What happens if you run the equivalent of an ALL button playlist query in sql mode? Select * From StarterHistory -jp .
| |
| notchback 10/27/2010 12:57:11 PM | --quote: "What happens if you run the equivalent of an ALL button playlist query in sql mode?--end quote I will give it a shot when I get home this evening. Thanks, Doug
| |
| notchback 10/27/2010 9:37:24 PM | query start: 10/27/2010 6:34:36 PM query end: 10/27/2010 6:34:36 PM elapsed time: 0 seconds Data Window Settings: 999 Divisor Odds Cap: None SQL: SELECT * FROM STARTERHISTORY Data Summary Win Place Show Mutuel Totals 0.00 0.00 0.00 Bet 0.00 0.00 0.00 Gain 0.00 0.00 0.00 Wins 0 0 0 Plays 0 0 0 PCT .0000 .0000 .0000 ROI 0.0000 0.0000 0.0000 Avg Mut 0.00 0.00 0.00 By: 21 TheOdds >=Min < Max Gain Bet Roi Wins Plays Pct 0.00 0.00 0.00 0.00 0.0000 0 0 .0000 0.00 0.00 0.00 0.00 0.0000 0 0 .0000 0.00 0.00 0.00 0.00 0.0000 0 0 .0000 0.00 0.00 0.00 0.00 0.0000 0 0 .0000 0.00 0.00 0.00 0.00 0.0000 0 0 .0000 0.00 0.00 0.00 0.00 0.0000 0 0 .0000 0.00 0.00 0.00 0.00 0.0000 0 0 .0000 0.00 0.00 0.00 0.00 0.0000 0 0 .0000 0.00 0.00 0.00 0.00 0.0000 0 0 .0000 0.00 0.00 0.00 0.00 0.0000 0 0 .0000 0.00 0.00 0.00 0.00 0.0000 0 0 .0000 0.00 0.00 0.00 0.00 0.0000 0 0 .0000 0.00 0.00 0.00 0.00 0.0000 0 0 .0000 0.00 0.00 0.00 0.00 0.0000 0 0 .0000 0.00 0.00 0.00 0.00 0.0000 0 0 .0000 0.00 0.00 0.00 0.00 0.0000 0 0 .0000 0.00 0.00 0.00 0.00 0.0000 0 0 .0000 0.00 0.00 0.00 0.00 0.0000 0 0 .0000 0.00 0.00 0.00 0.00 0.0000 0 0 .0000 0.00 0.00 0.00 0.00 0.0000 0 0 .0000
| |
| notchback 10/28/2010 9:22:54 AM | Hi Jeff, Maybe I should post in the tech support forum? Just let me know. I just did a #3 build on my 2009 Q3 folder (.eg files) Here is the screen shot showing # of SQL records  Now when I closed that window, I got this message:  And when I closed that window, I got this error:  Then when I closed that error, I got the build complete window again. I closed that and got a message indicating the session was already open and then JCapper closed by itself. I don't know if this is related but, it this is the second time it happened when I built this database. Doug
| |
| notchback 10/28/2010 9:57:00 AM | Oddly, with all those errors, the SQL query worked in the above database. Now I am scratching my head...
| |
| jeff 10/28/2010 11:24:30 AM | I'd like to have a look at the folders where your data and results files are stored to verify that there are no corrupt files and that data and results files from different years aren't "mixed" on the same folder. I'd also like to have a look inside of the JCapper2.mdb file. Both the .mdb file and the database folders are too large to email as an attachments. I'll ask my web host to create an FTP folder for you on my server. After they have it set up, I'll email you a userid and password so that you can open up that ftp folder on my server and simply copy and paste your database folders and c:\JCapper\Exe\JCapper2.mdb file to the ftp folder on my server... which will enable me to pull them down to one of my local machines and have a look. I'll have a better idea what's going on once I take a look at both. -jp .
| |
| notchback 10/28/2010 12:48:25 PM | Thanks Jeff. No big hurry. I don't even know how to use the SQL stuff yet. I just wanted to make sure everything was installed and set up correctly. Doug
|
| Reply |
|
Copyright © 2018 JCapper Software back to the JCapper Message Board www.JCapper.com |