Racehorse TALK

Releasing your code is an extremely generous offer TA. 

For those who want to use my program there a re afew things you need to get ready to use it.

Firstly you are going to need a copy of the mysql database installed.  It can be found at
http://dev.mysql.com/downloads/mysql/

When installing the program as root make the password root123
I have hardcoded this password into the program so if you don't set it to this then the prgram won't work.

Next you are going to need a copy of the java runtime enviroment.  Most computers have a copy of this now but if you need it you can get it from http://java.sun.com/javase/downloads/index.jsp  You only need the JRE unless you want to do your own coding.

Once you have these setup there is still the copy of the code and setting up the database.

The executable jar is attached.  Just extract it to a directory and you should be able to double click the HorseRacingDB.jar (depends on your jre).

Save table.sql to c:\

Next you need to open a command prompt (start - run - cmd) and type the following :

type "mysql -u root -p"

Enter your password of root123

type "create database pns;"

type "exit"

type "mysqldump -u root -p pns < c:\table.sql


Your database should now be created (but empty).

Double clicking the program should now work and the program should run fine.  You hit get Form to get the form daily.  Get Results will get the results from RISA and get Unitab data will get the data from unitab.  It will only record results/unitab data for those races for which ou have form.   It allows you to set how many days to go back for the results/unitab data.  Just leave this on 5 usually and you shouldn't have a problem

There are still lots of bugs but it is useable.

I'll improve it over time and will release the improvements to everyone.

[ ERROR: SPECIFIED ATTACHMENT MISSING ]

table,.sql was not attached. .

It is attched to this post.

[ ERROR: SPECIFIED ATTACHMENT MISSING ]

The program provided gets data from RISA and unitab.  Because of their copyright issues no prior data can be supplied.

Most of stuff is in FOXpro 

FOXpro ?

you dont know foxpro

one of the best databases for handling huge data, straight up sql statments.

Do you know of

Sybase, Oracle, Foxpro, these are all SQL based.

Yep


I just used mysql cause its free.
I used java to code it cause its free.
I get the data from RISA and unitab cause its easy and free.

A quick  bug ... well mainly because I didn't need to fix it for myself ...
1. "Load system"  button doesn't work. I put it there but never found a use for it as I could grab the sql and run it against the database.  to do this just download toad for mysql, but then you need to learn SQL.

If some people end up using this program I'll fix it up.

fair enough .

so let me get this right, you are using RISA reults and UNitab data YES ?
and no other data .

I use RISA Form data.
I use RISA results (cause it has full results)
I use the Unitab XML feed for further form data (and comparison with RISA data).  I mainly grab the unitab rating, track condition and various pool prices/results.

At the moment yes ... no other data.

I intend to get the data from racingandsports as well.

That's it and nothing else ?  not being smart, just asking.