|Subject||Re: Searching with TIB_Edit|
what is the syntax for using IN for filtering data with TIB_Edit
--- In IBObjects@y..., Geoff Worboys <geoff@t...> wrote:
> > But I would like to know, what are the other options and if the
> > can enter coumpound condition like "(>10 and <100) or (>1000)".
> Unless Jason has added something recently there is no support for OR
> statements when searching in IB_Edit.
> Other than using =, >, < etc operators you can also use all the
> various sql operators...
> is null
> is not null
> not like
> not starting
> not containing
> not in
> not between
> I think that about covers it.
> Geoff Worboys
> Telesis Computing