DRF SINGLE FILE FORMAT

[formula_2002]

I'm getting too old for this.
12 years ago I used the DRF single and then double file formats.

I just tried to re-create the process and did not do too well.

Does anyone have a data base structure for this beast?

Joe M

[Jeff P]

Joe M,

Bris has it on their site at:

http://www.brisnet.com/cgi-bin/static.cgi?page=drfsff


and


http://www.brisnet.com/cgi-bin/static.cgi?page=drfmff

[DJofSD]

Jeff gave you the two URL's. Check them periodically because BRIS does add information to unused fields on occasion.

Some one else in another thread was asking about optional claimers in allowance races. I've got an item on my to do list to check to see if this has been added to the list for race types (field 9).

DJofSD

[BillW]

Originally posted by DJofSD
Jeff gave you the two URL's. Check them periodically because BRIS does add information to unused fields on occasion.

Some one else in another thread was asking about optional claimers in allowance races. I've got an item on my to do list to check to see if this has been added to the list for race types (field 9).

DJofSD

"CO" was added quite awhile ago (few years).

Bill

[Jeff P]

"CO" was added quite awhile ago (few years).

They are also using a code of "ACO" for allowance optional claiming races. Check out the 5th at CRC today for an example.

The logic in my programs currently checks for a match using the code of "CO" only. So if the race is coded as "ACO" my software finds a match for race type and then treats these races the same in terms of race type as a "CO" race.

Not sure exactly how long they have been using "ACO" or how much it really matters to break out "CO" and "ACO" races separately.

[formula_2002]

Originally posted by Jeff P
Joe M,

Bris has it on their site at:

http://www.brisnet.com/cgi-bin/static.cgi?page=drfsff
and
http://www.brisnet.com/cgi-bin/static.cgi?page=drfmff

I was wanting the actual data base structure for the above. I thought at one time bris issued it. I did not want to create one .

Thanks
Joe M

[BillW]

Originally posted by Jeff P
"CO" was added quite awhile ago (few years).

They are also using a code of "ACO" for allowance optional claiming races. Check out the 5th at CRC today for an example.

The logic in my programs currently checks for a match using the code of "CO" only. So if the race is coded as "ACO" my software finds a match for race type and then treats these races the same in terms of race type as a "CO" race.

Not sure exactly how long they have been using "ACO" or how much it really matters to break out "CO" and "ACO" races separately.

While we're talking about creative abbrevs, watch out for TF. "Fast" in a dyslexic sort of way (maybe turf- fast? - seems to be used for turf races, intermixed with FT).

BTW tks for the heads up on the ACO, guess I need to pick up the effort of scrubbing my database for anomylous data.

Bill

[BillW]

Originally posted by formula_2002
I was wanting the actual data base structure for the above. I thought at one time bris issued it. I did not want to create one .

Thanks
Joe M

I don't understand your request. Do you want a recommended schema? or the SQL code? I've never seen anything like this at the Bris site.