Subject | Re: [IBO] Re: Searching with TIB_Edit |
---|---|
Author | Andreas Pohl |
Post date | 2002-05-08T09:43:05Z |
> > what is the syntax for using IN for filtering data with TIB_EditEspecially for country codes that are using commas as decimal separators.
>
> example: IN(59,67,105,256)
>
> IMPORTANT: Note that there must be NO SPACE between 'IN' and '('
> if you provide a space you get an SQL error. I wonder if we could
> improve this a little bit - make it more resilient to user input.
For now it is important to write
IN( 70 , 80 , 100 )
if search field is numeric!!