Logical Operations in @if in select statements

[Rainer Ebert]

 Posted by:  Rainer Ebert 

It would be very very helpful, if the first parameter of the function @if in
select statements could contain logical operations like =, , >=. So
that you e.g. can select as value column a or column b depending on which of
them is lager. Like "select @if( a > b, a, b ) from mytable".

Rainer

[Clifford W. Bass]

 Posted by:  Clifford W. Bass 

Hello Gupta,

I enthusiastically second that!

Clifford Bass

[Scott]

 Posted by:  Scott Booth 

Not ideal, but it does work...

@if( a > b, a, b ) can be implemented as @if((b - a) + @abs(b - a),a,b)

[Clifford W. Bass]

 Posted by:  Clifford W. Bass 

Hi Scott,

Yeah, there are some workarounds, but they are clunky and not easily
understandable by anyone who is not familiar with them. And, more
importantly, you cannot do text comparisons. Date comparisons are tricky to
accomplish. If you want to use ANDs and ORs and NOTs it gets even more
convoluted. MS Access lets you do all kinds of conditions / calculations in
their IIf() function and it just plain blows SQLBase out of the water for
ease of use.

My $0.02 worth,

Clifford Bass

[Fridolin Schwarz]

 Posted by:  Fridolin Schwarz 


ANSI-SQL supports a CASE-command. When does SQLBase?

fritz

[Rainer Ebert]

 Posted by:  Rainer Ebert 

I agree that it would be nice to have a CASE-command in SQLBase.

Rainer