Topic: Incorrect changing SQL condition

Hi!
I use SqlitePass 0.55 components in Delphi 7.
Situation:
create table w(f1 text(9));
insert into w(f1) values ("   1   ");
select * from w where f1="   1   ";

When select statement is assigned, it is converted to the:
select * from w where f1=" 1 ";

and of course the output I get an empty set!!!

Re: Incorrect changing SQL condition

Hi,

I am working on the parser to avoid similar bugs. (several blankspaces or text field begining with numeric values...etc).

Should be fixed in the next release.

Thanks

Re: Incorrect changing SQL condition

to get around the bug, I use such code
select * from w where trim (f1) = Trim (:par);

Thanks, waiting for fixex