Add result to DB soon as race is over

Question

I really need to have a table where the latest result (including Betfair SP) is added, automatically,  as soon as the race is over and result is known. At the moment I do this manually. But I know it could be automated.

I have some knowledge of programming, but I'm not a computer genius. How can I do this??

Answer 1

We receive summary results in real-time but update them in full the next day in Smartform.  How much of the result do you need to know? (please reply with comment to the question)

Comments

The only things I need to know are the name (or number) of the winning horse and it's SP.

---

ok - are you after this as an additional smartform table on top of the current historic races and runners tables?

---

An additional table might be easiest to use but it doesn't really matter, as long as the data is available somewhere in the database as soon as possible after the race has finished.

---

ok, we'll look at doing this.  To set your expectations will be unlikely before Christmas, but it's very doable, just have to work out how to automate for customers' local dbase

---

Thanks, Colin. Perhaps the automation could be done via a local script that checks for updates every minute during race times. I am using Linux (with PERL) so it shouldn't be too difficult.