Re: Informix SE on Solaris, using ACE report writer...
From: Carlos Benjamin <benj@firstlinux.net>
>
>--- "Obnoxio The Clown" <obnoxio@hotmail.com>
> > wrote:
> >From: Carlos Benjamin <benj@firstlinux.net>
> >>
> >>--- mars1972@my-deja.com
> >> > wrote:
> >> >Unless I'm missing something, you can only have one SQL statement in
>an
> >> >ACE report. What you might want to do is create a stored procedure
>that
> >> >figures out all the records you want and call the stored procedure in
> >> >the SQL section of the ACE report.
> >> >
> >>
> >>I believe you can do multiple SQL's in an ACE report. You could, for
> >>instance, in the ON EVERY ROW portion of the report select some info
>from a
> >>table based on one of the already selected rows (to get a description
> >>perhaps).
> >
> >From the ISQL reference manual, page 4-37:
> >
> >"The SELECT section begins with the SELECT keyword. This keyword
>introduces
> >both the SELECT section and the first SELECT statement. Other SELECT
> >statements can follow the first'each must begin with the SELECT keyword.
>All
> >SELECT statements, except for the last, must end with a semicolon. (If>there
> >is only one SELECT statement, it does not require a semicolon.) The
>SELECT
> >section ends with the END keyword. All but the last SELECT statement must
> >have an INTO TEMP clause."
>
>Thank you for that SELECT passage.
I hallways do my best.
> >I didn't have to read this to know it, but I did have to read it to prove
> >it. :-)
>
>To prove you could read?
That too.
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
In article <8lmds2$nai$1@news.xmission.com>,
"Obnoxio The Clown" <obnoxio@hotmail.com> wrote:
>
> From: Carlos Benjamin <benj@firstlinux.net>
> >
> >--- "Obnoxio The Clown" <obnoxio@hotmail.com>
> > > wrote:
> > >From: Carlos Benjamin <benj@firstlinux.net>
> > >>
> > >>--- mars1972@my-deja.com
> > >> > wrote:
> > >> >Unless I'm missing something, you can only have one SQL
statement in
> >an
> > >> >ACE report. What you might want to do is create a stored
procedure
> >that
> > >> >figures out all the records you want and call the stored
procedure in
> > >> >the SQL section of the ACE report.
> > >> >
> > >>
> > >>I believe you can do multiple SQL's in an ACE report. You could,
for
> > >>instance, in the ON EVERY ROW portion of the report select some
info
> >from a
> > >>table based on one of the already selected rows (to get a
description
> > >>perhaps).
> > >
> > >From the ISQL reference manual, page 4-37:
> > >
> > >"The SELECT section begins with the SELECT keyword. This keyword
> >introduces
> > >both the SELECT section and the first SELECT statement. Other
SELECT
> > >statements can follow the first'each must begin with the SELECT
keyword.
> >All
> > >SELECT statements, except for the last, must end with a semicolon.
(If> >there
> > >is only one SELECT statement, it does not require a semicolon.) The
> >SELECT
> > >section ends with the END keyword. All but the last SELECT
statement must
> > >have an INTO TEMP clause."
> >
> >Thank you for that SELECT passage.
>
> I hallways do my best.
>
> > >I didn't have to read this to know it, but I did have to read it to
prove
> > >it. :-)
> >
> >To prove you could read?
>
> That too.
>
That explains it then. I can read, (sort of) but I've never found any
doc on ACE. I even called Informix and they told me they didn't print
it anymore...
________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at
http://www.hotmail.com
>
>
--
# unrm /
ksh: unrm: not found
# man cpio
Sent via Deja.com http://www.deja.com/
Before you buy.
mars1972@my-deja.com wrote: > That explains it then. I can read, (sort of) but I've never found any > doc on ACE. I even called Informix and they told me they didn't print > it anymore... There's never been a whole manual dedicated to ACE; you can still buy the 7.30 ISQL manual which covers ACE and Perform and User Menus and so on. What's worse, depending on who you ask, people might or might not be aware that (a) ISQL is still a product and (b) that ACE is a part of ISQL. So people might assume that since they've never heard of the product, and you admit it is old when they ask about it, it must not be available any more. 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). 2. Because you can only use a SELECT statement in the SELECT section, the issue of the notation for LET x = SELECT ... is moot. -- 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!"