AQi vs. AQU...what's up with that?

[Donnie]

Maybe this should go in the Access Thread...but I wanted everyone to see this....

it appears that HTR2001 is exporting AQU files as AQi, while the other exporters are using the AQU code....

I know that I could probably do a "find and replace" so my table links work, but is anyone doing anything different, any other tricks you may know that make it quicker and easier?

BOL all!

[MikeDee]

I mentioned this to Ken and he is going to fix it, something to do with equibase and HDW and how they handle the AQI/AQI thing. To make matters worse once you add resutls htr2001 reverts back to AQU so you have AQI pre-results and AQU post results when you export.

What I have been doing is running a update query when I bring in my files that updates aqi to aqu, when I am pre results. This keeps the name consistent with my db.

IMO opinion AQI is, in effect, a different track and it should have it's own name. My preference would be for HTR/HDW to always use AQi. But we need for it to be consistent one way or the other.

[Donnie]

I never add results! You don't have to if you never pick the winners!!:D Saves me a ton of time, tho!!

Actually this came up as I was developing a db for another subscriber....guess I should use the exporters a little more often!

I agree with you Mike...AQi is different. Guess I will have to rig up a macro and put a button on the form to update the table during the winter months!

Thanks!

[MikeDee]

one good thing about not adding results......you never have any spot plays with negative ROI's:)

[Ken Massa]

I gave up the fight to fix the AQU and the AQi. It is all AQU in the new export. Our racefiles designate the "inner dirt" surface, but when the results come in, they switch it to "dirt". The answer is for Equibase to change the actual track name in the file to AQI. Not my fault, but I tried to remedy it, no avail. Sorry. Query your AQU by date to get the inner-data isolated.

[Donnie]

Ken- another answer for those serious about this could do an update query where in the date field you put the criteria "> opening date for inner track" and in the criteria for track put AQU and update above that to AQi...the serious 'capper will then change their own tables to AQi.

Thanks for the update! Appreciate it!

[MikeDee]

I keep all my master data table by track so I simply keep a AQI table that has the AQU racefiles for the inner track.