I've tried to do a statment like ...

select
 othertable.field,
 if ( (select count(field) from table where condition) > 0 THEN 'result' ELSE 'not result')
from
 othertable
where
 condition


Is it not possible to use a select statment as a way to create an expression, for an if function? Even if I took out the other table, and just try to do a select for an expression, I can't get it to
work.

Thanks

Thad <thollingsworth@paychex.com> wrote:

I've tried to do a statment like ...

select
 othertable.field,
 if ( (select count(field) from table where condition) > 0 THEN 'result' ELSE 'not result')
from
 othertable
where
 condition


Is it not possible to use a select statment as a way to create an expression, for an if function? Even if I took out the other table, and just try to do a select for an expression, I can't get it to
work.

Thanks


By the way, its DBISAM 4.x and Delphi 2005

Thad,

<< Is it not possible to use a select statment as a way to create an
expression, for an if function? Even if I took out the other table, and just
try to do a select for an expression, I can't get it to work.  >>

Not in DBISAM, no.  You can only use SELECT expressions with an IN or NOT IN
operator in DBISAM.

--
Tim Young
Elevate Software
www.elevatesoft.com