Jason, after examining the code I've realized that I've completely forgetten
'BETWEEN' keyword.

But I still think that it may be usefull to give the end user the choice of
using 'AND' / 'OR' logical phrases.

And I think this enhancement can be done in IB_Parse.Pas >
ExtractWhereClause procedure. Is this right?

After doing this, the next step could be defining these keywords in
IB_Constants.Pas. And by this way, enduser can use his/her native language
in search criterias..

Should I proceed? Does it worth?

Regards
Cagatay Tengiz

----- Original Message -----
From: Jason Wharton
To: IBObjects@yahoogroups.com
Sent: Monday, October 21, 2002 6:13 PM
Subject: Re: [IBO] Using multiple critearia in search panel


You have to use the BETWEEN <Aval> AND <AVal> structure.
You can also use IN( <aval>, <aval>, ... ) as well.

There is no logical combining multiple expressions in the search criteria
unless you enhance the built-in parsing using the provided events.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

-- We may not have it all together --
-- But together we have it all --


----- Original Message -----
From: "Helen Borrie" <helebor@...>
To: <IBObjects@yahoogroups.com>
Sent: Monday, October 21, 2002 5:56 AM
Subject: Re: [IBO] Using multiple critearia in search panel


At 03:56 PM 21-10-02 +0300, Çaðatay Tengiz wrote:
>Is it possible to use multiple search criteria in search panel edit boxes
>etc. like
>
> >100 AND <200
>
>which will be converted to
>
>where ATABLE.ACOLUMN > 100 and ATABLE.ACOLUMN < 200

Yes.

Helen




Yahoo! Groups Sponsor
ADVERTISEMENT




___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

__________________________________________________
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com