|
JCapper Message Board JCapper 101
|
| Home |
Register
Log In |
| By | Shippers... | |
| notchback 3/15/2011 5:40:06 PM | Anyone figured out a way to flag shippers in SQL mode? Maybe it is in a post somewhere and I just can't find it... Thanks, Doug
| |
| jeff 3/15/2011 10:36:19 PM | Older thread - SQL Shippers: http://www.jcapper.com/messageboard/TopicReader.asp?topic=757&forum=JCapper%20101 -jp .
| |
| notchback 3/16/2011 12:10:24 AM | Figured it was a previously asked question. Thanks Jeff.
| |
| busseb 3/16/2011 2:53:46 PM | and Track <> Tracklast worked for me. ElPaso
| |
| jeff 3/16/2011 5:10:43 PM | Yes. Track <> Tracklast can be used instead of the INSTR command. However, Track <> Tracklast doesn't flag shippers all by itself. You still have to deal with first time starters - otherwise the UDM ends up flagging shippers and first time starters both. In more detail... For all horses, the Track field contains the 3 character track code for today's track. However, for first time starters, the TrackLast field is empty. When the sql expression Track <> Tracklast is evaluated for a first time starter, Track is not equal to TrackLast... and the result is that a UDM designed to flag shippers ends up flagging first time starters in addition to shippers - unless there is another line in the UDM designed to exclude first time starters. For instructions on how to handle shippers in a sql udm, see the above linked to thread. -jp .
|
| Reply |
|
Copyright © 2018 JCapper Software back to the JCapper Message Board www.JCapper.com |