TZTable Filter "bug" costs me about 32 hours of st

[rfwoolf]

I have spent the past 5 days on and off trying my best to find out why my application isn't working since I changed to FireBird and Zeos.

Because my application has a 3rd party set of components it was a lot of code to read through and a lot of testing to try and find the problem. I wasn't getting any "errors" but it was not functioning correctly.

After spending DAYS changing my database to FireBird and changing all my datasets to ZEOS's TZTable and all my fields -- I thought it would all be a waste.

Please, next time put this in your Readme or QuickStart or part of the most important information:
-The Filter property of TZTable is quirky, and it accepts dates in the form of double, so 01/01/2008 might actually be 323231 - and you won't get any error if you use the wrong date format - the filter will just perform incorrectly.

Sigh.... What a nightmare

[mdaems]

Now you know the filering inside out, why don't you write a knowledge base article about it?

Or tell me exactly what text to add where?

Mark