The most recent fixes (see last post) included the ability to lock years. In order to do this I added a column called 'Locked' to the Years table. Here's the code:
ALTER TABLE `IGOR`.`Years` ADD COLUMN `Locked` TINYINT NOT NULL DEFAULT 0 AFTER `Current`;That's a zero, not an oh above. The locked value is 1 for any year that you no longer wish to have IE data entered for on the GUI. It won't affect the file repository--you'll still be able to archive files for prior years (it's always a possibility that someone will finally dig those minutes out and send them up to IGOR).