|
JCapper Message Board JCapper 101
|
| Home |
Register
Log In |
| By | Error:9Description:Subscript out of range | |
| jager fury 12/28/2010 5:11:58 PM | This is the error message when I try and run my SQL UDM with by Trainer as my breakout factor with the UDM Wizard. What is occuring to cause this error message? Thank you, Jager ~Edited by: jager fury on: 12/28/2010 at: 5:11:58 PM~
| |
| notchback 12/28/2010 9:34:12 PM | Try compacting and repairing your database. Worked for me... Make a backup of your jcapper2.mdb file first.
| |
| jager fury 12/29/2010 8:47:38 AM | I'm sorry, it actually breaks down when I try to query the entire data base. When I run a SQL UDM, the break out factor works fine. Tried the repair, but it didn't seem to do anything with this particular problem.
| |
| ryesteve 12/29/2010 5:26:42 PM | If it happens when you're querying the whole database, it probably means that your db is so large, the number of unique trainer names exceeds the max number that Jeff's code anticipated.
| |
| jeff 12/30/2010 1:54:56 PM | Drove through Utah last night through a nasty snowstorm... Am in Las Vegas this morning. Created a JCapper dev environment on one of the laptops -- Stepping through code in the Data Window that deals with the reporting arrays: The upper limit is 1000 cxn names. Adding name number 1001 to the array results in the error message. I'll work on upgrading the array to allow it to hold more names. -jp .
| |
| jeff 1/1/2011 4:07:09 PM | The 12/31/2010 program update contains an updated cxn names array... I was able to run an All Button BY TRAINER query against a database spanning all tracks everywhere for the 2nd half of 2010. The routine (which I ran overnight) ran to completion with no errors. -jp .
| |
| jager fury 1/11/2011 11:44:15 PM | Have not been back to check this out, but it seems Jeff has been thurough once again... :)
|
| Reply |
|
Copyright © 2018 JCapper Software back to the JCapper Message Board www.JCapper.com |