Hi Tobias,

I did make it this way a few months ago:

SELECT CAST(1 AS INTEGER), NAME1, CAST(gpreis AS FLOAT) FROM AUFTRAG
UNION
SELECT CAST(2 AS INTEGER), CAST('' AS CHAR(42)), CAST(SUM(gpreis) AS
FLOAT FROM AUFTRAG
ORDER BY 1

Bye Andre



-----Ursprüngliche Nachricht-----
Von: news@... [mailto:news@...] Im Auftrag von
Boris Schlüszler
Gesendet: Dienstag, 25. Juni 2002 20:21
An: IBObjects@yahoogroups.com
Betreff: Re: [IBO] TIB_Grid, add rows manually

Hi Tobias!

It gets complicated to scroll into it then...

Regards,

Tobias Giesen schrieb:

>
> > In the grid, I'd like to add one rows
> > at the very end.
> > E.g. select sum(val1), sum(val2) from table;
> >
> > Any ideas?
>
> Use a separate grid which you make 1 row in height.
>
> Cheers,
> Tobias
>
>
>

________________________________________________________________________
___

> IB Objects - direct, complete, custom connectivity to Firebird or

InterBase

> without the need for BDE, ODBC or any other layer.
>

________________________________________________________________________
___

> http://www.ibobjects.com - your IBO community resource for Tech Info

papers,

> keyword-searchable FAQ, community code contributions and more !
>
> Your use of Yahoo! Groups is subject to

http://docs.yahoo.com/info/terms/


________________________________________________________________________
___
IB Objects - direct, complete, custom connectivity to Firebird or
InterBase
without the need for BDE, ODBC or any other layer.
________________________________________________________________________
___
http://www.ibobjects.com - your IBO community resource for Tech Info
papers,
keyword-searchable FAQ, community code contributions and more !


Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/