Re: Informix SE on Solaris, using ACE report writer...

--- Jonathan Leffler <jleffler@informix.com> > wrote: >On Wed, 26 Jul 2000, Carlos Benjamin wrote: >>--- Jonathan Leffler <jleffler@informix.com> wrote: >>>As has been pointed out, the answers to the original question are: >>>1. You can use multiple select statements separated by semicolons >>> in the SELECT section of an ACE report (and not in the FORMAT >>> section of an ACE report -- if you think otherwise, you are >>> confusing I4GL reports with ACE reports). >> >>Well, I knew you could do more than one select, but I was (nearly) >>certain we had some within the format section of the reports.... but >>that was half a continent and a long time ago.... > >In standard ISQL/ACE, you cannot write SELECT statements in the FORMAT >section. > >IF ((your SELECT statement returns a single value) AND > (your custom ACE runner has a suitable ESQL/C function)) THEN >BEGIN > You could write a function call in the FORMAT section of the > report which passed in a string containing a SELECT statement > and collected the return value. >END Nope. We used plain ol' ISQL (and plain ol' SE before that) so no custom runners or function calls. Like I said, it's been a long time.... I'll try to hunt up some of the old source code if I have it. > >However, you could always write a string containing a SELECT statement >in the body of any report. It's cheating slightly to claim that a >string containing a SELECT statement is a SELECT statement. >Syntactically, strings are very different from executable SELECT >statements. > >-- >Yours, >Jonathan Leffler (Jonathan.Leffler@Informix.com) #include <disclaimer.h> >Guardian of DBD::Informix v1.00.PC1 -- http://www.perl.com/CPAN > "I don't suffer from insanity; I enjoy every minute of it!" == Maintainer of the procrastinator's FAQ. Well, maybe tomorrow I will be. _____________________________________________________________ Want a new web-based email account ? ---> http://www.firstlinux.net