Restrictive Page.Activate event and Insert, Update or Delete data.

Hi All
we have encountered an issue with the Page.Activate event and saving data. We have resolved the issue and I'd like to post our solution. I have searched for the issue on this site and can not see anyone asking for help however appologises nonetheless for repetition if this situation has been covered.

Page PeopleCode events only permits a DML SQL commands (Insert,Delete...) to called particular circumstances. These events are well documented - look for PeopleBooks Component Process workflow Post Change, Save Change etc.