Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

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