Subject | [IBO] Error in TIBOQuery |
---|---|
Author | Jan Turner |
Post date | 2002-03-26T10:18:32Z |
I have a TIBOQuery component in D5 with the following SQL statement:
'Select (Sum(Menge*Preis)+Sum(Versicherungspreis)) from Orderd where
(Linknummer="12345") and (retoure="1") and (NOT (Zaehler in (Select Zaehler
from Rueckzaehler where Ordernummer="12345")))'
As soon as I open the query, I get an error message telling me something of
an invalid column reference. this worked with IBO3 but started to generate
the error after upgrading to IBO4 and firebird 1.0
Thanks in advance
Jan Turner
----------------------------------------------------------------------------
www.getgo.de - Ihr Full-Service-Ticketprovider
getgo.de
Jan Turner
Albert-Einstein-Ring 10
D-22761 Hamburg
Fon: 040.41 911-310
Fax: 040.41 911-111
Mobil: 0177-9395729
jan.turner@...
----------------------------------------------------------------------------
'Select (Sum(Menge*Preis)+Sum(Versicherungspreis)) from Orderd where
(Linknummer="12345") and (retoure="1") and (NOT (Zaehler in (Select Zaehler
from Rueckzaehler where Ordernummer="12345")))'
As soon as I open the query, I get an error message telling me something of
an invalid column reference. this worked with IBO3 but started to generate
the error after upgrading to IBO4 and firebird 1.0
Thanks in advance
Jan Turner
----------------------------------------------------------------------------
www.getgo.de - Ihr Full-Service-Ticketprovider
getgo.de
Jan Turner
Albert-Einstein-Ring 10
D-22761 Hamburg
Fon: 040.41 911-310
Fax: 040.41 911-111
Mobil: 0177-9395729
jan.turner@...
----------------------------------------------------------------------------