Subject | Adding OR condition to where clause |
---|---|
Author | Andreas Pohl |
Post date | 2001-05-01T00:32:33Z |
I've got no success to add an additional OR condition after applying a
search criteria. What I'm trying to do is to select not only matching
records/sets but also assigned "parent" records/sets, e.g.
ID RunningNr
-- -----------
1 001.
2 001.001
3 001.002
...
If record ID 2 is matching search criteria so record ID 1 must be shown,
too. AddWhereClause is using AND and brackets so there is no way to use OR ,
e.g.
"where VisualSearchCriteria OR MyInvisibleCondition"
Is anybody out there already solved this kind of problem?
Mit freundlichem Gruss & Best Regards
Andreas Pohl
apohl@...
www.ibp-consult.com
search criteria. What I'm trying to do is to select not only matching
records/sets but also assigned "parent" records/sets, e.g.
ID RunningNr
-- -----------
1 001.
2 001.001
3 001.002
...
If record ID 2 is matching search criteria so record ID 1 must be shown,
too. AddWhereClause is using AND and brackets so there is no way to use OR ,
e.g.
"where VisualSearchCriteria OR MyInvisibleCondition"
Is anybody out there already solved this kind of problem?
Mit freundlichem Gruss & Best Regards
Andreas Pohl
apohl@...
www.ibp-consult.com