Subject Re: [IBO] Using multiple critearia in search panel
Author Cagatay Tengiz
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?

Cagatay Tengiz

----- Original Message -----
From: Jason Wharton
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

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

----- Original Message -----
From: "Helen Borrie" <helebor@...>
To: <>
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



Yahoo! Groups Sponsor

IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________ - 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