case results not showing in editor

[Bart Pietercil]

On 3-okt-07, at 22:37, Ivan Smahin wrote:

> Hello Danny,
>
> Wednesday, October 3, 2007, 11:33:32 AM, you wrote:
>
>> Hi List, Ivan,
>
>> when I call this procedure :
>
>> create or replace procedure ct_select_competences_module(in
>> intModuleID long, IN intOrganisationID LONG, IN strSelectList  
>> VARCHAR)
>> Begin
>>         CASE strSelectList
>>         WHEN 'Module' THEN
>>                 SElect RecID, objptr_module, objptr_comppool->name  
>> As competence_name,
>>                 objptr_comppool->description As comp_description FROM
>> tbl_comppool_modules
>>                 WHERE objptr_module = intModuleID;
>>         WHEN 'All' THEN
>>                 SELECT RecID, name, description FROM  
>> tbl_competence_pool
>>                 WHERE RecID NOT IN (SELECT objptr_comppool FROM
>> tbl_comppool_modules WHERE objptr_module = 1) AND objptr_organisation
>> = intOrganisationID;
>>         ELSE
>>                 SELECT 1;
>>         END CASE
>> END
>
>> After calling this procedure like this :
>> CALL ct_select_competences_module(1, 1, 'All'),
>> I get 1 as Query Result, so the ELSE statement is executed.
>
>
>> So, I guess, the case-statement can NOT compare VARCHARS ?????
>> Same result with the IF-statement...
>
>> Guess this is a bug..??
>
> Yes - I have reproduced it.


Good, so go to bed now :-)


Bart