Subject Re: [firebird-support] Re: where field = any
Author James
Hi Robert,

You got a nice suggestion. Although two SQL statement would be of more
work but what you said is right, it would be more clear. So my question
is to reprepare the SQL will this be slower? or more usage on resources?

Thanks.


James
Robert martin wrote:

> Hi
>
> Wouldn't the whole thing be easier to maintain if it was two SQL
> statements, one that is used for All results and the other that is a
> subset of the results?
>
> It seems to me that someone else looking at the code could better
> understand what is going on if the statement was changed depending on
> the circumstance. After all the query needs to be re run every time
> you change the parameter anyway. I guess the only thing you gain by
> doing it as below (which I think is really clever) is that you
> wouldn't need to re prepare the SQL like you would with two SQL's.
>
> Just my 2c
>
>
> Rob Martin
> Software Engineer
>
> phone 03 377 0495
> fax 03 377 0496
> web www.chreos.com
> Wild Software Ltd
> ----- Original Message -----
> From: James
> To: firebird-support@yahoogroups.com
> Sent: Thursday, October 21, 2004 3:06 PM
> Subject: Re: [firebird-support] Re: where field = any
>
>
> Hi Miroslav,
>
> You got a nice answer here, but concerning on what svein erling posted,
> if I had 1=0 will this scan the whole table and slow down the whole
> thing?
>
> Thanks
>
>
> James
>
> Miroslav Penchev wrote:
>
> > On Tue, 19 Oct 2004 06:40:07 -0000, Svein Erling Tysvær
> > <svein.erling.tysvaer@...> wrote:
> >
> > >
> > >> What about this?
> > >>
> > >> WHERE 1=1 OR FieldA =:ANY
> > >
> > > 1=1 will always be true, so every record will be returned regardless
> > > of whether FieldA = :ANY or not.
> >
> > The "real" statement is:
> >
> > WHERE 1=:ACTIVE_FILTER OR FieldA =:ANY
> >
> > where :ACTIVE_FILTER is 0 or 1.
> >
> > --
> > Miroslav Penchev
> >
> >
> > *Yahoo! Groups Sponsor*
> > ADVERTISEMENT
> >
> <http://us.ard.yahoo.com/SIG=129es1q1r/M=294855.5468653.6549235.3001176/D=groups/S=1705115386:HM/EXP=1098289574/A=2376776/R=0/SIG=11ldm1jvc/*http://promotions.yahoo.com/ydomains2004/index.html>
>
> >
> >
> >
> >
> ------------------------------------------------------------------------
> > *Yahoo! Groups Links*
> >
> > * To visit your group on the web, go to:
> > http://groups.yahoo.com/group/firebird-support/
> >
> > * To unsubscribe from this group, send an email to:
> > firebird-support-unsubscribe@yahoogroups.com
> >
> <mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>
> >
> > * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> > Service <http://docs.yahoo.com/info/terms/>.
> >
> >
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
>
>
>
>
>
> ------------------------------------------------------------------------------
> Yahoo! Groups Links
>
> a.. To visit your group on the web, go to:
> http://groups.yahoo.com/group/firebird-support/
>
> b.. To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
> c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service.
>
>
>
> [Non-text portions of this message have been removed]
>
>
> *Yahoo! Groups Sponsor*
> ADVERTISEMENT
> <http://us.ard.yahoo.com/SIG=1297oq8n1/M=294855.5468653.6549235.3001176/D=groups/S=1705115386:HM/EXP=1098411001/A=2376776/R=0/SIG=11ldm1jvc/*http://promotions.yahoo.com/ydomains2004/index.html>
>
>
>
> ------------------------------------------------------------------------
> *Yahoo! Groups Links*
>
> * To visit your group on the web, go to:
> http://groups.yahoo.com/group/firebird-support/
>
> * To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
> <mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/>.
>
>