> -----Original Message-----
> From: Torsten Grundke [mailto:tgrundke@...]
> Sent: Domingo 21 de Enero de 2001 5:25
>
> Hi,
>
> I have IBO-version 3.5. I can set ib_query.prepared = true (no error-
> message). I open the SQL-Editor with a douple-click of ib_query. I
> can't prepared the statement error-message is "Fieldname: not found".
> The result of the statement without sum "select total_value from
> sales" is ok.

Put a label to the column:
sum(field) as somelabel

This is a bug in IB. An engine is supposed to not only give a name to all
columns, but to give each column a unique name. IBX simply assigns aebitrary
names when it doesn't get a name.
SUM and AVG were spoiled in dialect 3. They at least produced some names
before in IB.

C.