|
JCapper Message Board JCapper 101
|
| Home |
Register
Log In |
| By | Track Test | |
| rosenowsr 1/18/2012 7:51:13 AM | When the box "this track test" is checked does that mean only past performance lines that were run at that track will be used ? Or is it meant to make the UDM track specific? Also I can't get "new pace top" to work in my SQL can you show me how to insert a multi name factor that is not listed as a rank item. I read the cheat sheet and it still didn't sink in. I just discovered SQL, it looks more intimidating than it is. In less than an hour including, watching the videos and reading the articles,I was writing SQL UDM's. I know nothing about computer language or programming. Thanks Jeff, I am having a great time with this program.
| |
| jeff 1/18/2012 12:30:33 PM | The track test box is designed for making a playlist file UDM track specific. Just check the box, key a list of track codes separated by dash characters (example: AQU-BEL-SAR-WOX) into the Restrict TrackList field, and hit the save button. To make a sql UDM track specific add a line containing desired track codes to the sql expression driving the UDM. Examples: AND TRACK='AQU' AND INSTR('AQU-BEL-SAR-WOX', TRACK) > 0 -jp .
| |
| jeff 1/18/2012 12:41:16 PM | Numeric values for New Pace Top are recorded in the PaceTop field of the StarterHistory table. PaceTop values stored in the table (as defined in theTable Schema Doc) are 0, 1, 2, and 3. To add a factor constraint for New Pace Top to a sql UDM, add a line that defines min and/or max values you want the UDM to handle. Examples: AND PACETOP > 0 AND PACETOP < 3 AND PACETOP BETWEEN 1 AND 3 Hint: After adding each new line of sql to a UDM, double check your work by running the UDM through the Data Window with the query results broken out by the factor being handled (in this case New Pace Top.) -jp .
| |
| rosenowsr 1/18/2012 1:20:32 PM | Thanks Jeff for helping an oldman, lol. I was trying to add rank or val or gap to the non SQL names. Such as "new top pace". Got it now though. Thanks P.S. Your willingness to help answer questions is worth the price of the program alone.
| |
| Charli125 1/19/2012 1:34:21 PM | Jeff said: Hint: After adding each new line of sql to a UDM, double check your work by running the UDM through the Data Window with the query results broken out by the factor being handled (in this case New Pace Top.) That's excellent advice that everyone should use. I've found myself making small mistakes that would've been huge by doing this. Things like using > instead of < are just one key away but make a huge difference.
|
| Reply |
|
Copyright © 2018 JCapper Software back to the JCapper Message Board www.JCapper.com |