The PSION Organiser II Homepage
Forum Home Forum Home Help Help Search Search Members Members Login Login Register Register

Welcome, Guest. Please Login or Register.
Why register?
   The Psion Organiser II Forum
   User Forum
   User Post
   Post reply ( Re: More - What can I use my Organiser for? )
Post reply
Full name:
Message icon:
Add Smileys:
Disable Smilies:

Check this if you'll be adding code (or don't like smileys).

Before submitting, please enter the verification code in the box below.

Topic Summary - Displaying 1 posts. Click here to show all
Posted by: MartinReid Posted on: Dec 1st, 2018, 12:58pm
Dear all
This is another of my 'What can I use my Organiser for?' threads.  
For those looking at OPL and database management.
Last time it was a 616 UK birds species ODB.;action=display;num=153558 0571
This time I've got consent from Adrian Massey - - to post some of his horse racing data. The RaceODB.Zip contains an 128k OPK with three ODB files on it. Jockeys.ODB 418 Records, Trainers.ODB 536 records, Horse.ODB 1028 race favourite records Jan to November 2018. So anyone interested in horse racing and looking to practice working with multiple related databases has plenty to go at. If you need you can break open the OPK in Jaaps OPK File Editor.
If for example you were considering the 14:05 at Newcastle (today) the 1st December 2018 and wanted to consider the favourite Buveur D'Air ridden by B.Geraghty and trained by N Henderson. You could cross reference the databases to find..
Buveur D'Air was the winning favourite at Sansown on 3rd Feb, with Jockey B.Geraghty placed 142 times from 386 races was trained by Nicky Henderson who has been placed 224 times from 464 runners.
I'll let you know later how it went on.
Anyway again sincerely and in good faith
Samples from databases (the 1st record contains the field names)
Jockey Name - Rides - Wins - Places - Adrian Massey Rating    
A E LYNCH 623 36 145 99
A P HESKIN 234 30 70 75
AARON JONES 184 10 34 83
ADAM KIRBY 781 121 290 88
Trainer Name - Runners - Wins - Places - Adrian Massey Rating    
A J MARTIN 247 8 45 97
A OLIVER 95 14 30 135
A P O'BRIEN 501 70 166 135
ADAM WEST 148 9 24 99
Date - Race - Favourite Horse - Position - Starting Price
01-Jan-18 1:55 Fakenham  ARTIFICE SIVOLA 1/6.  5-2.
01-Jan-18 2:35 Cheltenham  RED RISING 2/8.  11-4.
01-Jan-18 2:50 Musselburgh CASTLETOWN 3/9.  4-1.
01-Jan-18 3:05 Fakenham  NORSE LIGHT 2/2.  1-2.

The Psion Organiser II Forum » Powered by YaBB 1 Gold - SP 1.1!
YaBB 2000-2002,
Xnull. All Rights Reserved.