Re: ACE Report Compiler Problem v4.0x to v4.1x

In article <miltwebbCs2FKK.FBC@netcom.com> miltwebb@netcom.com writes: > We experienced the following problem upgrading from ISQL v4.0 to v4.1. > Many of our reports will compile with the 4.1 product but produce the > following run-time error. (This is on an RS-6000) > > The column "" is not in the current table, or > the user variable "" has not been defined. > Source code line number 0. > See error number -9004. > > A call to Informix Support resulted in being informed that our reports > were to big for the compiler. These reports will compile and run under > the old 2.1 version on DOS -or- UNIX and run fine. The only work around > I had was to compile them under 4.0 (on an obsolete platform here) and > then ship the .arcs to the RS-6000 and SCO boxes. There was no compile > time error on these. We have a simlar problem with some reports on 4.0 > > I can't beleive that the compiler broke going from 4.0 to 4.1 and that > Informix Support doesn't consider this a problem. No I think they just changed where it was broke ;-) However there seem to be two solutions. 1) Play with individual line lengths in your ace source until the compiler will accept it. This seems to be the trigger. 2) Switch to isqlperl for your reports which is what we have decided to do as it is a much more flexible tool! > > I would welcome a dialogue with any Informix staff frequenting this forum. > -- > ------------------------------------------------------------------------------ > Milt Webb | email addresses> miltwebb@netcom.com > Servantis Systems, Inc. | mfw@servantis.com > 4411 East Jones Bridge Road | mfw@atl.fujikura.com > Norcross, GA 30092 | Phone 404/840-1365(W) or 404/945-5896(H) > -- Clive Eisen Email ceisen@deepthwt.demon.co.uk Clive Eisen Computing Phone (+44) 71 281 1414