TZTable Filter "bug" costs me about 32 hours of st
Posted: 04.10.2008, 23:39
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
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