|
JCapper Message Board JCapper 101
|
| Home |
Register
Log In |
| By | SQL Mode raw distance and surface shift | |
| jeff 1/10/2010 11:56:43 AM | From the email inbox this morning... --quote: "Jeff, How do I add raw distance to a sql mode udm?"--end quote Distance is in yards... there are 220 yards in a furlong... field name in the Table Schema is "dist" without the quotes. Example: You want route races which is 1760 yards and up... AND DIST >= 1760 Another: You want sprint races which is less than 1760 yards... AND DIST < 1760 Another: You want 6f races only... 220 yds per furlong times 6 equals 1320... use a SQL Expression like this: AND DIST = 1320 --quote: "Also how do I make a surface shift udm in sql?"--end quote Surface Shift in sql mode doesn't (yet) display in the Data Window like it does in playlist file mode. That doesn't prevent you from using surface shift in sql mode UDMs. Kick the Data Window into playlist file mode and run an ALL Button query broken out by Surface Shift... You'll see the data broken out into 17 separate categories... each category having a number for surface shift. Make note of the numbers designating each surface shift category. (Cut and paste the output directly from the Data Window into Notepad and save as a text file if need be.) Then put the Data Window back into SQL Mode. You are going to use the exact same sfshift category numbers in sql mode as you would in playlist file mode when adding surface shift to sql mode UDMs... Field name in the Table Schema is "sfshift" without the quotes. Example: You want "T to D" which is Surface Shift 4... Use a SQL Expression like this one... AND SFSHIFT = 4 Another example: You want all categories for Turf to turf... That's sfshift 12 through 15... use two lines in your SQL Expression... like this: AND SFSHIFT >= 12 AND SFSHIFT <= 15 -jp .
|
| Reply |
|
Copyright © 2018 JCapper Software back to the JCapper Message Board www.JCapper.com |