Re: SYSTEM call from trigger error

Jonathan Oei wrote: > We are using Informix On-Line 7.20.UC3 and have a simple trigger on a > table that fires after an insert. During the trigger, we build a > string that contains a path to an external .4ge program. > > So far, so good, this has been working for months. > > But now, we get this error from the trigger trace: > > exception : looking for handler > SQL error = -668 ISAM error = -172 error string = = ""> exception : no appropriate handler [cutting] If it working from command line and not from the trigger then it must be path, permissions or environment. Change the 4ge to a simple shell script that records its running environment and compare it to that of the working command line code. -- Paul Watson # WF Software Ltd # If it ain't broke, Tel: +44 1436 674729 # fix it till it is. Fax: +44 1436 678693 # www.wfsoftware.co.uk #