Database Handicapping Software- JCapper

JCapper Message Board

          JCapper 101
                      -- Can I search for a horse by name or Dam in the sql data window.

Home Register
Log In
By Can I search for a horse by name or Dam in the sql data window.
bartsharkattack
3/18/2015
10:49:06 AM
I am looking for babies of horses I bred or raced in the past. I saw one mare I bred had a filly in Indiana with four starts, just thought it would be cool to pull up her pp's but i have no idea where or when she raced.

Reply
jeff
3/18/2015
2:54:53 PM
Very easy to do.

The following sql expression is one example of how to pull up all records for a specific horse from your StarterHistory Table:

Select * from StarterHistory WHERE HORSENAME = 'SHARED BELIEF'




The following sql expression is one example of how to pull up every record for a specific sire from your StarterHistory Table:

Select * from StarterHistory WHERE SIRE = 'TAPIT'




The following sql expression is one example of how to pull up every record for a specific dam from your StarterHistory Table:

Select * from StarterHistory WHERE DAM = 'ESPECIALLY AWESOME'




Hint: To see the individual plays, select "+ Show Individual Plays" from the drop down before executing the query.

Also, just as with any sql expression, you can add constraints using any of the fields listed in the Table Schema Doc.


-jp

.


Reply
Reply

Copyright 2018 JCapper Software              back to the JCapper Message Board              www.JCapper.com