I'll display the track code on reports and pps.
The one thing track name related I do have to check at the start of each new meet is the track_name entry stored in one of my tables for purposes of parsing the Equibase Scratches and Changes XML for each track.
Equibase seems to change the track_name in the xml every time a track changes its name.
Another of those 1,000 paper cut things that need to be handled.
Imo, maintaining data integrity would be so much easier if every track were issued a genuine unique identifier (a text code, a number, it really doesn't matter) that stays the same unless a track is torn down and rebuilt from the ground up (for example River Downs and Belterra Park.)
clickable thumbnails below showing track_name Horseshoe Indianapolis
-jp
.
__________________
Team JCapper: 2011 PAIHL Regular Season ROI Leader after 15 weeks
www.JCapper.com
Last edited by Jeff P; 08-20-2022 at 04:01 PM.
|