Re: ACE report question.
It is a bit annoying, isn't it?
What I do is to select my unions into a temp table, then select back
out from the temp table, this time ordering by the column name. Then
it works.
eg
[...]
select last_name, [....]
from kith
union
select surname, [....]
from kin
into temp kith_and_kin ;
# The first column in temp table "kith_and_kin" is named "last_name",
# although both "last_name" and "surname" data go into it.
select last_name, [.....]
from kith_and_kin
order by last_name
end
format
before group of last_name
print last_name;
on every row
print [.....]
[...]
In article <6ejg1r$pfv@hpaneqb4.an.hp.com>,
Jim Kistler <kistler@an.hp.com> wrote:
>Reading INFORMIX-SQL Reference Manual Version 4.0, page 5-54 on the subject
>"BEFORE GROUP OF" I see:
>
> 6. You cannot use an integer to indicate by which column of the
> select-list the grouping it to occur.
>
>I have a report using "UNION" between three "SELECT" statements where
>I MUST use the column numbers in the "ORDER BY" list and the ACE report
>compiler seems to insist that I also use a number to reference the selected
>column with a "BEFORE GROUP OF" statement!
>
>I'm running ISQL 4.14 and I see no other "hint" in the "release"
>documentation.
>
>What am I missing? Do I need a documentation "update"?
>
>Thanks,
>
>Jim
>--
> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=#=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
> Jim Kistler - kistler@an.hp.com # Some see issues and ask, "Why?
> Hewlett-Packard Co. Imaging Systems # Others see opportunities and
> 3000 Minuteman Road, Andover, MA 01810 # ask, "Why not?"
> TEL: 978-659-2251 - FAX: 978-687-7265 #
> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=#=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Others see difficulties
and say "No way!"