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

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 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!"