Subject | Re: [IBO] Error in TIBOQuery |
---|---|
Author | Svein Erling Tysvær |
Post date | 2002-03-26T10:44:08Z |
Jan,
your SQL statement is incorrect. Using double quotes (") indicates a column
reference, and I bet you don't have columns named "12345". If you want to
compare string columns with constant values, use single quotes (').
I.e.
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')))
should work (unless Linknummer, retoure or Ordernummer is defined as some
kind of number).
HTH,
Set
your SQL statement is incorrect. Using double quotes (") indicates a column
reference, and I bet you don't have columns named "12345". If you want to
compare string columns with constant values, use single quotes (').
I.e.
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')))
should work (unless Linknummer, retoure or Ordernummer is defined as some
kind of number).
HTH,
Set