case results not showing in editor

[Ivan Smahin]

Hello Danny,

Wednesday, October 3, 2007, 12:40:41 PM, you wrote:

> Hi again,

> another problem has occured with this stored procedure...
> When added more than 1 record int the table tbl_comppool_modules, the
> stored procedure returns faulty records!
> The first record added to tbl_comppool_modules is not shown anymore,  
> which is correct. But the other records I insert into  
> tbl_comppool_modules, the stored procedure still returns them!! Very  
> strange, because when I run the query

>> 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;

> Outside the stored procedure, it runs perfectly...

Strange. Could you send me that database?


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