Subject Re: "All" parameter variable
Author rodbracher
I do use ORs but the optimiser is really bad at working with these -
but having thought about it suppose if there was a 'Symbol' I was
thinking about this would amount to the same thing with the optimiser.

Rod

--- In firebird-support@yahoogroups.com, "ibrahim bulut"
<i.bulut@i...> wrote:
> Hi,
> I am doing that with my style.
>
> SQL= 'select * from mytable where mydate = :mydate or 'ALL'
= :GETALL'
>
> Button1.click;
> ==========
> query1.close,
> query1.params[0].value:=Null;
> query1.params[1].value:=Null;
>
> if All=True Then query1.parambyname('GETALL').value:='ALL'
> Else query1.parambyname('mydate').asdate:=dateedit1.date;
> query1.open;
>
>
> if you pass 'ALL' to getall parameter, query fetches all the record.
>
>
>
> ibrahim Bulut
> Software/Database Developer
> Republic Of Turkey
>
> ----- Original Message -----
> From: "rodbracher" <rod@m...>
> To: <firebird-support@yahoogroups.com>
> Sent: Monday, October 20, 2003 1:58 PM
> Subject: [firebird-support] "All" parameter variable
>
>
> > Hi
> >
> > If I had a query
> > select * from mytable where mydate = :date
> >
> > There is often the case you want to consider all dates. This would
> > essentially mean removing the where condition - but it would be
> > easier to have the query "know" to ignore that parameter if some
> > symbol is passed in.
> >
> > This is a rather simple case, but when you have many parameters -
> > each one being an option to use or not - it is a pain building
SQL in
> > code to cater for all permutations.
> >
> > Is there such a thing ?
> >
> > FB 1.0.3
> >
> > Thanks
> >
> > Rod
> >
> >
> >
> > To unsubscribe from this group, send an email to:
> > firebird-support-unsubscribe@yahoogroups.com
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
> >
> >
> >