filtersql error

[donlego]

hi .. i try use filtersql in ibcquery like this

Code: Select all

with ibcquery1 do
begin
close;
open;
filtersql:=  'ANIMAL.ID<>' + QuotedStr('-100') + '';
filtered:=true;
end;

but i got the error
dynamic sql error
sql error code =-104
unexpected end of command - line 62,column 26

i use ibdac 4.1.6

[donlego]

this is my query in ibcquery

Code: Select all

select * from animal where 
kelompok=1
--and nama<>'tiger'

it got error if on where clause i have commented

but if i remove the commnted clause and my query change to

Code: Select all

select * from animal where 
kelompok=1

and i filtersql it work

hm... something strange

[ZEuS]

Thank you for the information. We know about the problem and have fixed it in the past. Please try using the latest IBDAC version 5.0.2 where there is no such error.