SQL issue solved

My Access SQL problem is solved.  Access can’t do what I wanted to do but the folks at WinSwim modified their custom SQL query report to allow for error supression which solves the problem.  I just can’t say enough about the excellent support from WinSwim.

I don’t know how most swim teams manage their swimmers but ours revolves around age groups.  Everything is organized by age group, coordianted by age group, reported by age group, etc.  I have been creating Win Swim Reports using Crystal Reports to present the data in the database in a format our team is used to seeing it it.

Working on these reports is the primary reason I haven’t made much progress on the plugin lately.  Swim team is winding down, our last meet is tomorrow night and once the season is over I expect to be able to work on the plugin again.  There are a number of things I’d like to implement while the experience is still fresh in my memory.  If I wait I’ll probably forget why I thought something was a good idea!  🙂

Struggling with MS Access

While it isn’t really relevant to the wp-swimteam plugin, it is related to swim team.  Our team is using WinSwim for meet management which relies on Crystal Reports for generating reports.  I have been customizing reports for our team and am working on one which requires me to really poke into Access.

I have done quite a bit of work with MySQL so it is frustrating to encounter SQL constructs which Access doen’t support.  Right now I am struggling with how to determine if a table in Access already exists and if it does, I want to drop it.  What a PITA.  Access doesn’t support the DROP TABLE IF EXISTS construct which MySQL (and others) support.

If you know how to do this, please tell me how in the comments!  🙂