Recent

Author Topic: TDbf - a problem with filtering numeric fields  (Read 4923 times)

vrull

  • Full Member
  • ***
  • Posts: 118
TDbf - a problem with filtering numeric fields
« on: March 11, 2008, 11:28:29 pm »
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

  • Jr. Member
  • **
  • Posts: 84
RE: TDbf - a problem with filtering numeric fields
« Reply #1 on: March 13, 2008, 12:50:54 pm »
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

  • Full Member
  • ***
  • Posts: 118
The bug is reported
« Reply #2 on: March 13, 2008, 09:02:24 pm »
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

  • Jr. Member
  • **
  • Posts: 84
RE: The bug is reported
« Reply #3 on: March 13, 2008, 09:36:42 pm »
Funny, I dind't try this. :-)

 

TinyPortal © 2005-2018