case results not showing in editor

[Ivan Smahin]

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.


-- 
Best regards,
Ivan Smahin 
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com