Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 4 of 4 total |
Bug i filter function? |
Thu, May 3 2007 11:52 AM | Permanent Link |
Paul B | I'm playing around with a recently bought ElevateDB, version 1.02 on an XP-OS, considering migration of a number of hard tested applications based on DBISAM tables.
Conversion to the new format has been surprisingly simple and efficient, so up to this point I have been quite happy. However, I have run into something, that seems like a bug. Our users perform a number of searches in some of the tables, based on setting various filters on specific fields. Take a (simplified) table with a field "DESCR" containing the following values ALFA 133 ALFA 160 BETA 200 BETA 220 BETA 300 Setting a filter expression DESCR LIKE 'A%', correctly gives a result of 2 records Filter DESCR LIKE 'BETA%' gives the expected 3 records Filter DESCR LIKE 'BETA %' (notice the space character) results in 0 (zero) records and Filter DESCR LIKE 'BETA 2%' again gives the expected 2 records The same results are given if I use a filter expression in the format DESCR = 'xxx*'. I have tried to use the filter in a small test-application and using the elevateDB Manager. Results are equal in both cases. Is this a bug - or am I missing something important?? Best regards Paul B |
Thu, May 3 2007 1:47 PM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Paul
I think its the trailing space issue. What datatype is the field CHAR or VARCHAR? Roy Lambert |
Thu, May 3 2007 4:21 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Paul,
<< Take a (simplified) table with a field "DESCR" containing the following values ALFA 133 ALFA 160 BETA 200 BETA 220 BETA 300 Setting a filter expression DESCR LIKE 'A%', correctly gives a result of 2 records Filter DESCR LIKE 'BETA%' gives the expected 3 records Filter DESCR LIKE 'BETA %' (notice the space character) results in 0 (zero) records and Filter DESCR LIKE 'BETA 2%' again gives the expected 2 records The same results are given if I use a filter expression in the format DESCR = 'xxx*'. >> It's a bug. It has to do with the trailing blank trimming during searching combined with partial-length searches with a trailing wildcard. A fix will be in 1.03. -- Tim Young Elevate Software www.elevatesoft.com |
Thu, May 3 2007 4:44 PM | Permanent Link |
Paul B | "Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote:
>It's a bug. It has to do with the trailing blank trimming during searching >combined with partial-length searches with a trailing wildcard. A fix will >be in 1.03. -- Thanks a lot for a quick reply. Best regards, Paul B |
This web page was last updated on Monday, May 6, 2024 at 03:23 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |