Re: Insert triggers, is this a bug, is there a work around?

In article <35324736.4638FB94@callamer.com>, David Zepp <issac@callamer.com> writes >Help..... > > I'd like to change a "LastUpdatedBy" column on a table in an insert and > >update trigger, rather than from the application. > >Works with update, but not with insert (error -747). Documentation >backs this up, says you cannot reference the triggering table in a >triggered SQL statement, if the trigger EVENT is an INSERT. Did >Informix cripple their triggers like this for a reason? Has anyone To simply the code??? >found a clean way way around this? (Other than using another DBMS) > Not really... >Thanks, >David Zepp >dzepp@ssfab.com > -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care