Re: Query with NULL

From: Robert Klemme <shortcutter_at_googlemail.com>
Date: Thu, 31 Dec 2009 12:24:49 +0100
Message-ID: <7q3g01FqcnU1_at_mid.individual.net>

On 12/31/2009 09:58 AM, bob123 wrote:
> OK thanks all ...
> The problem is that i can't rewrite the code
> it's a third party software ...
> any clue ?

Difficult... You can't easily use stored outlines because those would be optimal for a single of the four cases. You may get away with outlines in four different categories but then you somehow need to switch between them before the statement is executed. I guess everything you attempt will soon get messy. Is there no chance to get the vendor of the application to change it? Maybe you can file it as bug and get a resolution via your support contract.

Good luck!

        robert

-- 
remember.guy do |as, often| as.you_can - without end
http://blog.rubybestpractices.com/

Received on Thu Dec 31 2009 - 05:24:49 CST