--- In firebird-support@yahoogroups.com, "Sasha" <selectnull@...> wrote:

>
> >
> > How can I easily query an integer column to get the rows matching
> > an integer or also allow all rows to be fetched? EG:
> >
> > Item.Project (integer)
> > Item.Location (integer)
> >
> > (Case 1)
> > Select * from Item where
> > Project = :ProjectID and Location = LocationID
> >
> > (Case 2)
> > Select * from Item where
> > Project = :ProjectID and Location = all locations
> >
>
> select * from Item where
> Project = :ProjectId and (Location = :LocationID or :all_locations = 1)
>
> case 1: set :all_location to 0
> case 2: set :all_location to 1
>
> Or, you can dynamically build a query and skip " and Location = ..."
>
> Sasha
>

Thanks Sasha,

I would really like to avoid building the query dynamically.

I don't understand:
case 1: set :all_location to 0
case 2: set :all_location to 1.

Is this some kind of switch to disregard this parameter? Where is
there documentation on this?