SELECT CASE method

jda jda at his.com
Mon Jul 18 19:40:57 CDT 2005


>Hi,
>Jon I have found the problem...
>
>Look. you use "select case..." in the method's text.
>
>It does not work this way.
>You need just "case..." - I mean throw away select statement.
>It is never used in the methods.
>
>I have tested this issue and it works.
>

OK. But just so you know, here are the examples from the Valentina 
sql documentation:

SELECT CASE 1 WHEN 1 THEN "one"
  WHEN 2 THEN "two" ELSE "more" END;
  => "one"
  SELECT CASE WHEN 1>0 THEN "true" ELSE "false" END;
  => "true"

I guess they should be changed.

I'll change my code.

Thanks again,

Jon



More information about the Valentina mailing list