Lazarus
Home
Help
TinyPortal
Search
Login
Register
Lazarus
»
Forum
»
Programming
»
Databases
»
TDbf - a problem with filtering numeric fields
Free Pascal
Website
Downloads
Wiki
Documentation
Bugtracker
Mailing List
Lazarus
Website
Downloads (Laz+FPC)
Packages (OPM)
FAQ
Wiki
Documentation (RTL/FCL/LCL)
Bugtracker
CCR Bugs
IRC channel
GIT
Mailing List
Other languages
Foundation
Website
Useful Wiki Links
Project Roadmap
Getting the Source
Screenshots
How to use the forum
About donations (wiki)
Bookstore
Computer Math and Games in Pascal
(preview)
Lazarus Handbook
Search
Advanced search
Recent
how to tweek fpmake to co...
by
paule32
[
Today
at 08:23:49 am]
splitting an image
by
paule32
[
Today
at 08:20:33 am]
Why isn't TTIRadioGroup's...
by
egsuh
[
Today
at 08:09:35 am]
FpDebug questions
by
440bx
[
Today
at 03:43:41 am]
Lazarus for Windows on aa...
by
Wallaby
[April 23, 2024, 11:46:56 pm]
Parameter passing odditie...
by
KodeZwerg
[April 23, 2024, 11:04:39 pm]
Can function be used for ...
by
jamie
[April 23, 2024, 10:53:10 pm]
(Solved) TIndexedAVLTree ...
by
lainz
[April 23, 2024, 10:49:03 pm]
Demo Scene Picture sinwav...
by
KodeZwerg
[April 23, 2024, 10:26:21 pm]
fkInternalCalc
by
zraja
[April 23, 2024, 09:31:07 pm]
A fairly simple sound sol...
by
KodeZwerg
[April 23, 2024, 09:23:37 pm]
add new targets to make
by
marcov
[April 23, 2024, 08:38:42 pm]
Quirky windows
by
ASerge
[April 23, 2024, 07:07:16 pm]
[Request] Demo Scene Sub ...
by
Gigatron
[April 23, 2024, 06:29:39 pm]
Unlocking Files
by
KodeZwerg
[April 23, 2024, 06:03:08 pm]
[SOLVED] trunk bug for mi...
by
Key-Real
[April 23, 2024, 05:56:32 pm]
Demo Scene Bitmap Font Sc...
by
Gigatron
[April 23, 2024, 05:56:27 pm]
Compile/Convert Delphi pr...
by
Martin_fr
[April 23, 2024, 05:43:11 pm]
Generics - correct syntax
by
Thaddy
[April 23, 2024, 05:40:59 pm]
InstallAware Using Lazaru...
by
msintle
[April 23, 2024, 05:26:36 pm]
Xcode Command Line Tools ...
by
Joseph
[April 23, 2024, 05:16:39 pm]
Offical launch of the 1 B...
by
Hartmut
[April 23, 2024, 04:49:29 pm]
what to do if my target M...
by
nickysn
[April 23, 2024, 04:16:02 pm]
compiler error in unit
by
paule32
[April 23, 2024, 03:49:50 pm]
Multithreading - synchron...
by
mika
[April 23, 2024, 01:48:51 pm]
« previous
next »
Print
Pages: [
1
]
Author
Topic: TDbf - a problem with filtering numeric fields (Read 5408 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?
Logged
gerardus
Jr. Member
Posts: 93
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
Logged
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:
Logged
gerardus
Jr. Member
Posts: 93
RE: The bug is reported
«
Reply #3 on:
March 13, 2008, 09:36:42 pm »
Funny, I dind't try this. :-)
Logged
Print
Pages: [
1
]
« previous
next »
Lazarus
»
Forum
»
Programming
»
Databases
»
TDbf - a problem with filtering numeric fields
TinyPortal
© 2005-2018