Subject | Re: [IBO] Adding OR condition to where clause |
---|---|
Author | Andreas Pohl |
Post date | 2001-05-01T02:44:04Z |
I'm not suggesting to deal with OR clauses. I tried to manipulate serversql
in OnBeforePrepare event and recognised that IBO detect my additions, set it
into brackets and adds search criterias, e.g.
IBO delivers first: 'where search_criterias'
I set in OnBeforPrepare: 'where ( search_criterias OR MyCondition )'
IBO delivers next time: ' where ( search_criterias OR MyCondition ) AND (
search_criterias )'
Here is IBO too smart for my needs :)
Mit freundlichem Gruss & Best Regards
Andreas Pohl
apohl@...
www.ibp-consult.com
in OnBeforePrepare event and recognised that IBO detect my additions, set it
into brackets and adds search criterias, e.g.
IBO delivers first: 'where search_criterias'
I set in OnBeforPrepare: 'where ( search_criterias OR MyCondition )'
IBO delivers next time: ' where ( search_criterias OR MyCondition ) AND (
search_criterias )'
Here is IBO too smart for my needs :)
Mit freundlichem Gruss & Best Regards
Andreas Pohl
apohl@...
www.ibp-consult.com