Page 1 of 1
filtersql error
Posted: Thu 29 Aug 2013 04:05
by 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
Re: filtersql error
Posted: Thu 29 Aug 2013 04:21
by 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
Re: filtersql error
Posted: Thu 29 Aug 2013 08:09
by 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.