Hi

#1
My query has sql:
'SELECT FIELD1, FIELD2, FIELD3 FROM TABLE'

and filter:
'FIELD1 collate pxw_plk CONTAINING ''abc'''

and it raises exception: 'token unkown AND'

IB_monitor shows:
'SELECT FIELD1, FIELD2 FROM TABLE
WHERE (FIELD1 collate pxw_plk AND CONTAINING ''abc'')'
^^^

#2
My query has sql as #1 above and filter:
'c(FIELD1)||c(FIELD2)||c(FIELD3) containing ''abc'''

and it raises exception:
'Invalid syntax: extra or missing parenthesis
(
c(kod) ||c (
skrot ) ||c
(
nazwa ) containing
'abc'
)'

amount of opening and closing parenthesis is equal. c() is udf from
rfunc.dll. IBO 4.8.7.
I did a fix in IB_Parse.pas from
http://tech.groups.yahoo.com/group/IBObjects/message/42136


Regards, Tomek