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
(Moderator: Mikesan)
   More - What can I use my Organiser for?
« Previous topic | Next topic »
Pages: 1  Reply Reply Notify of replies Notify of replies Send Topic Send Topic Print Print
   Author  Topic: More - What can I use my Organiser for?  (Read 23 times)
MartinReid
Mega Power Member




   
WWW

Posts: 116
More - What can I use my Organiser for?
« on: Dec 1st, 2018, 12:58pm »
Quote Quote Modify Modify

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.
http://forum.psion2.org/YaBB.pl?board=UserPost;action=display;num=153558 0571
 
This time I've got consent from Adrian Massey - http://adrianmassey.no-ip.org/web1/index.php - 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
Martin
 
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.
RaceODB.zip 30.3 kb
Pages: 1  Reply Reply Notify of replies Notify of replies Send Topic Send Topic Print Print

« Previous topic | Next topic »

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