Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM SQL » View Thread |
Messages 1 to 3 of 3 total |
SELECT as expression for IF |
Fri, Jan 19 2007 7:15 AM | Permanent Link |
Thad | 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 |
Fri, Jan 19 2007 7:19 AM | Permanent Link |
Thad | 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 |
Fri, Jan 19 2007 3:34 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
This web page was last updated on Sunday, May 5, 2024 at 10:18 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |