TDbf - a problem with filtering numeric fields
lazarus / 16-Databases

----------------------------------------------------------------------
vrull · 2008-03-11 22:28

I have found that I cannot apply a filter expression for numeric
fields, like ftFloat, ftInteger, if it contains a "minus" sign.
Like
Code: [Select]MyTable.Filter := 'fieldFloat = -10.00';

assuming that fieldFloat has ftFloat type.

The program returns an error message:
Index based on unknown field "-"

The expressions like

fieldFloat = 10.00
fieldFloat >10.00
fieldFloat <10.00

work just fine.
Any ideas how to solve this?

----------------------------------------------------------------------
gerardus · 2008-03-13 11:50

Hi,

You are right, it doesn't work. TDBF parser seems to parse C/C++-like
operators (&&, |, =!) but ignores a minus sign before a number.
I suggest you to open a bug report.

Regards,

Gerard

----------------------------------------------------------------------
vrull · 2008-03-13 20:02

Ok, the bug report is submitted.
So far I have found one funny workaround for the problem:
instead of using the obvious form "field=-10.00" one can set up
"field=0-10.00" and this will work. :lol:

----------------------------------------------------------------------
gerardus · 2008-03-13 20:36

Funny, I dind't try this. :-)