9.40.FC8 and TRIGGERS
Posted in 2006
We upgraded a server from 7.31.FD7 to 9.40.FC8, the stored procedures were all dropped/recreated as advised by Informix however we seem to have come across another problem in that an update trigger that invokes 3 stored procedures was failing (hence my question yesterday about SP's). We dropped the trigger and recreated it and everything now works perfectly. Am I right to surmise that triggers are affected by a V9 migration in the same way stored procedures are? Regards Colin There are 10 types of people in the world, those that understand binary and those that don't _________________________________________________________________ Windows Live' Messenger has arrived. Click here to download it for free! http://imagine-msn.com/messenger/launch80/?locale=en-gb