SELECT Name, Amount, TooHeavy
FROM xyz
where Amount>0

And TooHeavy shold be a boolean value
that is true for Amount>100,
else false

It doen't work with
SELECT Name, Amount , Amount>100 TooHeavy
delphi doesn't like the ">" in the Select-Statement.

Can this be achieved in another way ?

Any Ideas,
Post here AND EMAIL (please!!)

you could try a calculated field in the TQuery or TTable component. Right
click, select 'Create New Field' and select calculated. Then, in the
OnCalculateField-event, set the field to True if the amount > 100.
--
Martijn Tonies

<- remove some characters from my email adress to reply ->

http://www.upscene.demon.nl

Ralf Steinhaeusser heeft geschreven in bericht

What you could try (if I'm understanding what you are trying to do) is
something like this:

Select Name, Amount, 'True' As TooHeavy
from xyz
where
Amount > 100

HTH

And I'm using Paradox-tables

One way you can do this in local SQL is with a UNION join concatenating two
SELECT statements. Each of the two sub-statements would return rows that
meet one of two criteria: the Amount column contains a value greater than
100 or Amount is less than 100. A literal BOOLEAN value is given to the
TooHeavy column in these statements: a value of TRUE in the result set
where the first criteria is met and FALSE when the the second criteria is
met.

  SELECT Name, Amount, TRUE AS TooHeavy
  FROM xyz
  WHERE (Amount > 100)
  UNION ALL
  SELECT Name, Amount, FALSE
  FROM xyz
  WHERE (Amount > 0)

[...]

Looking at what I posted, believe the SQL was not quite what was needed.
Instead of this...

  SELECT Name, Amount, TRUE AS TooHeavy
  FROM xyz
  WHERE (Amount > 100)
  UNION ALL
  SELECT Name, Amount, FALSE
  FROM xyz
  WHERE (Amount > 0) AND (Amount <= 100)