| Subject | How to use a an integer parameter to fetch parameter = "N" or all rows. |
|---|---|
| Author | mitch_landor |
| Post date | 2007-05-30T07:34:44Z |
Im using TIBOQuery.
How can I easily query an integer column to get all 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
Thanks
Mitch
How can I easily query an integer column to get all 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
Thanks
Mitch