Re: Case in where-clause version dependent?

Hi Stefan,

First - 7.4 doesn't know TRUE or FALSE as stand alone expressions - so you need to do a compare.

Second - the the CASE expression is very strange IMHO.

Without testing it, this should work:

where Case :wildcard
When '%'
And objname like trim( :wxlib )
Then 1
When '*'
And objname = objname
Then 1
When ' '
And objname = :wxlib
Then 1
Else 0
End = 1

The case expression returns a value (here 1 or 0) and you have to compare it.

In 7.5 you can simply return TRUE or FALSE as these are a complete expression - it they don't exist in 7.4 or lower.

And better "flatten" the case expressions - no need for "else case" - a case can have multiple when and one else.

HTH
Daniel

Am 22.12.2024 um 10:08 schrieb stefan@xxxxxxxxxx:

where Case When :wildcard = '%'

Then objname like trim( :wxlib )

else

Case When :wildcard = '*'

Then objname = objname

else

Case When :wildcard = ' '

Then objname = :wxlib

end

end

end