Thanks for all the hints but I fear none of it worked.
I changed my SQL.Text to this:

Select (Sum(Menge*Preis)+Sum(Versicherungspreis)) as summe from Orderd where
(Linknummer=12345) and (retoure=1) and (NOT EXISTS (Select Zaehler from
Rueckzaehler where (Rueckzaehler.Ordernummer=12345) and
(Rueckzaehler.Zaehler=Orderd.Zaehler)))

I still get the error message telling me that there is an invalid column
reference.

With this:
Select (Sum(Menge*Preis)+Sum(Versicherungspreis)) as summe from Orderd where
(Linknummer=12345) and (retoure=1)

same Problem, so the bug must be within the select statement.
now I tried doing this on an older firebird classic server version but it
doesn't work either. But it worked on that database with IBO3 so I assume
that the error lies in my usage of IBO4 not in the database.

Thanks
Jan Turner



"Svein Erling Tysv�r" <svein.erling.tysvaer@...> schrieb im
Newsbeitrag news:3.0.1.32.20020326115914.009725f0@[158.36.132.22]...

> By the way Jan,
> by changing your SQL a bit, you may gain some speed:
>
> Select (Sum(Menge*Preis)+Sum(Versicherungspreis)) from Orderd
> where (Linknummer='12345') and (retoure='1')
> and (NOT EXISTS (Select 1 from Rueckzaehler
> where Rueckzaehler.Ordernummer='12345'
> and Rueckzaehler.Zaehler=Orderd.Zaehler))
>
> And if any of those numbers should happen to be defined as Integers (or
> anything not a string), drop the single quotes.
>
> Set
>
>
>

___________________________________________________________________________

> 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/
>
>
>