Ok. We have FB 1.5 in testing but don't want to use it in production yet.
Still too many "severe" sounding messages in the newsgroups on it (like
"server crash" and backup/restore problems).

This query is just a temp query so I did not want to use a stored procedure
but I guess I'll have to.

Thanks.


""Thomas Steinmaurer"" <ts@...> wrote in message
news:<FGEFIGLMFAKKKHHOJFHNEEOJEPAA.ts@...>...

> Don,
>
> > Select
> > SC
> > , substring(INDICATORS from 28 for 1) as IND28
> > , cast(sum(CABS_MSGS) as integer) as Cabs_Msgs
> > , cast(sum(ACCESS_TIME) as numeric(15,2)) as AccMins
> > from master
> > where
> > (data_source = 'CAB')
> > and (source_id = 2003032117)
> > Group by SC, IND28
> >
> > Group By does not accept field #'s (like 2).
>
> either create a view or stored procedure and
> group by SC and IND28 when querying the view
> or stored procedure.
>
> Firebird 1.5 supports GROUP BY <field_index>
>
>
>
> Regards,
> Thomas Steinmaurer
> http://www.iblogmanager.com
>
> See you at the First European Firebird Conference in May in Fulda, Germany
> http://www.firebird-conference.com
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>