Just think how much money you could have saved if you'd used PostgreqSQL then.
I am well aware of that. I was planning to do so. But others here preferred a non-DIY solution, on which we have spent many months of DIY to make it work.
This appears to be a common problem, as an LEA school we have this even worst than you do...
What are the chances of forming a purchasing group to fund my developing an OS system?
I tried to arrange that fourteen months ago, without success. Now the megabucks have been spent, the opportunity from my POV has past.
There are generally more useful things which can be done with megabucks.
However, you might be interested to know that the CMIS system has left plenty of room for any currently unanticipated results of future evolution of the human race. The "Sex" field on this system is CHAR(2).
Or you could make it double as a student ID :)
But the programmers (who hail from Dublin) created an import system that strips apostrophes from names.
I though Irish jokes wern't PC :) -- Mark Evans St. Peter's CofE High School Phone: +44 1392 204764 X109 Fax: +44 1392 204763