|
JCapper Message Board JCapper 101
|
| Home |
Register
Log In |
| By | trainer names in sql | |
| Acorn54 8/14/2025 11:39:22 PM | hi jeff acorn here. not sure if my sql udm will flag the trainer i want it to on race day when the trainer runs his horses. specifically i entered brad cox in the udm wizard and checked the box for trainer and format of trainers name is correct using hdw format. is this all i have to do. i did not enter brad cox in the sql expression when i pasted the expression from the sql expression wizard. i purposely took it out of the expression before pasting it to the udm wizard, thinking it wouldn't flag the udm, the way that happens when you use real time odds in the sql udm. never mind i figured out you have to include the trainer name in the udm sql expression. ~Edited by: Acorn54 on: 8/14/2025 at: 11:39:22 PM~
| |
| jeff 8/17/2025 10:09:00 AM | Glad you (quickly) figured it out. Some bullet points for benefit of anyone not familiar with sql mode who reads this: • You do need to include the CXN names (rider. trainer, etc.) in your sql expressions. • The objective is to get a name match between the names in your sql expressions and the names in the tables (StarterHistory, StarterHistory2025, StartersToday, StartersToday2025, etc.) • Getting perfect name matches is made easier if the CXN Names Formatting Setting in your Enhanced Settings Module is set to : "0 Remove Punctuation Characters" before you run SQL CalcRaces or SQL DBBuilds in modes 3,4, or 5. -jp .
|
| Reply |
|
Copyright © 2018 JCapper Software back to the JCapper Message Board www.JCapper.com |