Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB Connectivity » View Thread |
Messages 1 to 5 of 5 total |
ADO.NET driver WHERE LIKE clause broken in 210b1 and 211b1 |
Thu, Oct 18 2012 11:07 AM | Permanent Link |
Hedley Muscroft | I have just upgraded from 209b1 to 211b1 and using a WHERE LIKE clause with FILE BASED access via the ADO.NET returns incorrect results.
I tested this with 210b1 and 211b1 and both are broken - 209b1 works fine. This problem only manifests via the ADO.NET driver (the EDB Manager is fine) and when accessing the files directly in a folder rather than via C/S. Basically when you do :- SELECT * FROM atable WHERE afld LIKE 'Blob%' ... it's returning all sorts of records that it shouldn't. Please let me know if you need a sample project to demonstrate this - thanks. Hedley |
Thu, Oct 18 2012 11:38 AM | Permanent Link |
Raul Team Elevate | Hedley,
i suggest you email this direct to support@elevatesoft.com - you'll get a lot faster resolution as Tim might not read the newsgroups for few days. Raul On 10/18/2012 11:07 AM, Hedley Muscroft wrote: > I have just upgraded from 209b1 to 211b1 and using a WHERE LIKE clause with FILE BASED access via the ADO.NET returns incorrect results. > > I tested this with 210b1 and 211b1 and both are broken - 209b1 works fine. > > This problem only manifests via the ADO.NET driver (the EDB Manager is fine) and when accessing the files directly in a folder rather than via C/S. > > Basically when you do :- > SELECT * FROM atable WHERE afld LIKE 'Blob%' > .. it's returning all sorts of records that it shouldn't. > > Please let me know if you need a sample project to demonstrate this - thanks. > > Hedley > |
Thu, Oct 18 2012 6:02 PM | Permanent Link |
Hedley Muscroft | Thanks for the recommendation Raul - I've sent an email as suggested.
|
Mon, Oct 22 2012 6:08 AM | Permanent Link |
Hedley Muscroft | Just an update for anyone else having this issue - Tim has replied to my email as follows :-
>> I've reproduced the problem and will have a fix available in the next build, >> probably within the next 2 weeks. To summarise - if you're using the ADO.NET driver for direct access to the database files (i.e. not via the client/server "edbsvr") then do NOT use build 2.10 or 2.11 as the WHERE clause is broken. |
Mon, Nov 5 2012 4:21 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Hedley,
<< To summarise - if you're using the ADO.NET driver for direct access to the database files (i.e. not via the client/server "edbsvr") then do NOT use build 2.10 or 2.11 as the WHERE clause is broken. >> Clarification: the LIKE clause is broken, not the WHERE clause. Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Tuesday, September 17, 2024 at 04:19 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |