Subject SQL errors when usin TIB_SearchPanel
Author Salvatore Besso
hello all,

I'm testing latest beta 15 with BDS 2006. I'm making testing on
TIB_SearchPanel using some advanced search strings and I have discovered the
following:

IN predicate:

in(1, 5) works fine and returns rows

in(1,5) works but doesn't return any row (notice the missing space after
comma)

in (1,5) or
in (1, 5) give a strange behaviour:

When search is performed the first time it gives this error:

ISC ERROR MESSAGE:
Dynamic SQL Error
SQL error code = -104
Token unknown - line 12, column 18
in
.
STATEMENT:
TIB_Query: "<TApplication>.MembersDM.MembersQuery"

but the search executed other times gives only "No records found".

Regards
Salvatore