Hi,

>> is it possible to use the TIB_SearchPanel to find multiple values for the
> >> same field (i.e. use AND, OR, etc.)?
>
>AND here make no sense, isn´t it ?

For sure is not as useful as OR but can be used for ranges of values.
Particularly on ranges like minor of something AND major of something else.

> >>What would be a good way to indicate this in the search criteria syntax?
>
>Some Time ago, I made a parsing routine, written in C, to give the user
>the ability to do such a search. I used following chars to indicate:
>
>value | value means or for alpha and numerical (can be multiple
>or´s)
>value : value means in range for numerical only
>! value means not equal for alpha and numerical

This was similar to what I was thinking about with the only exception to
use double characters (i.e. || instead of | ) to avoid problems with fields
that may contain that particular character. I think also && for AND could
be useful if possible to be used as I wrote above.
Another nice thing would be to add the ability to define the relation
between the fields in the search, that for now is always AND but in some
cases could be useful to use OR also (maybe a dropdown near the field?).
Just an idea.

Thanks
Roberto

>If you like to see my parsing code, I could send it to you. It was
>written for
>a UNIX programm, using a informix database.
>
>Harald Klomann
>
>
>
>Jason Wharton wrote:
> >
> > > is it possible to use the TIB_SearchPanel to find multiple values for the
> > > same field (i.e. use AND, OR, etc.)?
> > > Sorry if this question has been already asked but I was unable to search
> > > the old archive of the mailing list and I didn't find anything in the
> > > samples/help.
> >
> > Usually IN( ) fulfils my needs but you are correct that there isn't a
> way to
> > use AND'd conditions in the search mode. I should add this to my things to
> > do.
> >
> > What would be a good way to indicate this in the search criteria syntax?
> >
> > Thanks,
> > Jason Wharton
> > CPS - Mesa AZ
> > http://www.ibobjects.com