|
JCapper Message Board JCapper 101
|
| Home |
Register
Log In |
| By | ClassDescriptor='G' or 'G1' ? | |
| bettheoverlay 11/4/2009 7:23:03 PM | I'm setting up some Graded Stakes UDMs for the Breeders Cup and confusing myself as to the proper ClassDescriptor. It appears that you have to use 'G1' 'G2' and 'G3' as the ClassDescriptor in the UDM definition for the UDM to appear on the HTML report. But in the Data Window, only the 'G' ClassDescriptor in queries will show any results for Graded Stakes. This is in SQL mode. . ~Edited by: bettheoverlay on: 11/4/2009 at: 7:23:03 PM~
| |
| ArlJim78 11/4/2009 7:45:01 PM | I came across the same thing recently. One solution I came up with is to use the LIKE or NOT LIKE command with a wildcard %. For example; classdescriptor LIKE 'G%', gives all G races 1,2 3 and classdescriptor NOT LIKE 'G%', excludes all G races.
| |
| bettheoverlay 11/4/2009 8:31:05 PM | I just changed my Class Descriptor definitions to your expression, Jim, and the change did indeed accomplish the task of the UDM appearing on the HTML report and in the data window query. Thanks much. .
| |
| Charlie James 11/13/2009 5:33:26 PM | Jeff, Hey, nice little program upgrade from yesterday. Looks like we can now differentiate graded stakes class descriptors in sql mode like so: AND CLASSDESCRIPTOR = 'G1' After installing yesterday's upgrade say I wanted to make a UDM grab horses in grade ones only, the above looks like it works everywhere now. Am I right? Chuck
| |
| jeff 11/13/2009 6:39:54 PM | Chuck, You have it exactly right. -jp .
|
| Reply |
|
Copyright © 2018 JCapper Software back to the JCapper Message Board www.JCapper.com |