Page 1 of 1
string concatenation problem
Posted: Mon 04 Oct 2010 15:17
by dilbert
I have encountered a strange problem with version 2.90.170. (The previous versions worked correctly.)
If I have a query with WHERE clause and if I use string concatenation in SELECT clause, then no records are returned.
Try this code:
Code: Select all
var query = from u in DB.Users
where u.Active == 1
select new { Name = u.Username + " abc " };
foreach(var row in query)
{
// no records returned;
}
Thanks for attention.
Posted: Tue 05 Oct 2010 14:19
by StanislavK
Thank you for your report, we have reproduced the problem. We will investigate it and inform you about the results as soon as possible.
Posted: Fri 26 Nov 2010 13:39
by dilbert
The problem still persits in the current version - 2.90.190.0.
Is there any progress with this issue?
Thanks
Posted: Mon 29 Nov 2010 17:26
by StanislavK
The problem is that SQLite apparently uses named parameters in the order they are specified, regardless of their names. We are working on this problem, and will inform you about the results as soon as possible.
Posted: Fri 10 Dec 2010 13:01
by StanislavK
We've implemented a workaround for this SQLite behaviour, queries with parameters (or literals) in the Select part should be processed correctly now. These changes will be available in the nearest build of dotConnect for SQLite.
Posted: Fri 17 Dec 2010 10:34
by StanislavK
We have released the new 3.0.69 version of dotConnect for SQLite where these changes are available. The new build can be downloaded from
http://www.devart.com/dotconnect/sqlite/download.html
(the trial version) or from Registered Users' Area (for users with active subscription only):
http://secure.devart.com/
For more information about the fixes and improvements available in dotConnect for SQLite 3.0.69, please refer to
http://www.devart.com/forums/viewtopic.php?t=19796