Hi Markus!

Thanks for your advice.
With your construct I'm running at least into this problem:
I have not yet found out, how to use SQLWhereItems with the UNION-clause

Thanks anyway.
I'm gonna think again about it, maybe I just add a panel at the bottom!

Regards, Boris

Markus Ostenried schrieb:

>
> At 21:23 Monday, 24.06.2002 +0200, you wrote:
> >Hi!
> >
> >Is there any way to get additional rows into a TIB_Grid?
> >I have a TIB_Grid, datasource to a query.
> >Query is something like this: "select val1, val2 from table"
> >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?
> >Regards, Boris
>
> maybe you can append this to your SQL Select statement:
> UNION select sum(val1), sum(val2) from table
>
> but I think you have to select the same fieldtypes
> after the UNION part as you select before it.
>
> e.g.
> SELECT
> field1 // e.g. 3 Varchar(20) fields
> , field2
> , field3
> , '1' as OrderField
> from TableA
> UNION
> SELECT
> cast(sum(val1) as Varchar(20))
> , cast(sum(val2) as Varchar(20))
> , cast('-' as Varchar(20))
> , '2' as OrderField
> from TableB
> ORDER BY 4
>
> But I don't know if you can make this so
> to have it updateable.
>
> HTH,
> Markus
>
>
> ___________________________________________________________________________
> 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/