Subject Re: [IBO] Adding OR condition to where clause
Author Andreas Pohl
According to IBO help and my experiences SQLWhereItems and original where
stuff (like search criterias) are always connected with AND. That might be
true in most cases. But I need to "soften" users search criterias without
losing IBO's in-form-searching-capabilities.

I would suggest to modify parsing algorithm in that way, that IBO omits to
add AND operator in case of first line of SQLWhereItems is OR or AND. Jason,
is there a way to support necessarily modifications made by me?

Mit freundlichem Gruss & Best Regards

Andreas Pohl
----- Original Message -----
From: "Geoff Worboys" <geoff@...>
To: <>
Sent: Tuesday, May 01, 2001 5:17 AM
Subject: Re: [IBO] Adding OR condition to where clause

> > Here is IBO too smart for my needs :)
> What you need to do is to use SQLWhereItems or SQLWhereHigh/Med/Low in
> the OnPrepareSQL event handler. (nb. SQLWhereItems are the same
> stringlist as SQLWhereMed). These strings are only valid during that
> phase and are not saved for future prepares.
> When you use the AddSQLWhereClause function you are adding permanently
> to the SQL statement - so if you call this function with every prepare
> you will get duplicate entries, as you have found.
> Geoff Worboys
> Telesis Computing