Subject | SQL errors when usin TIB_SearchPanel |
---|---|
Author | Salvatore Besso |
Post date | 2007-01-22T10:16:20Z |
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
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