DevForce Community Forum : Error: expression is more than 8000 chars long http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2009 : Error: expression is more than 8000 chars long Fri, 10 Apr 2026 20:04:32 -700 Mon, 10 Oct 2011 13:42:14 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=2996 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Error: expression is more than 8000 chars long : The error comes when trying... http://www.ideablade.com/forum/forum_posts.asp?TID=2996&PID=11786#11786 Author: kimj
Subject: 2996
Posted: 10-Oct-2011 at 1:42pm

The error comes when trying to run the query against cache using the DataTable.Select method.   This method does not have a hard ceiling of 8000 characters but does have a limitation as to query complexity, which DevForce for somewhat obscure reasons chose to interpet as an 8000 character limitation.  The character count does not include subqueries, which is why you may see larger queries work successfully.
 
This problem was "alleviated" in the DevForce 3.6.6 release so that the cache query check is not made when the QueryStategy is DataSourceOnly.   Unfortunately the only workaround in earlier releases is to modify the query to suit the limitation.]]> Mon, 10 Oct 2011 13:42:14 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2996&PID=11786#11786 Error: expression is more than 8000 chars long : We are runnning Ideablade Version:... http://www.ideablade.com/forum/forum_posts.asp?TID=2996&PID=11774#11774 Author: ngoel
Subject: 2996
Posted: 09-Oct-2011 at 5:32pm

We are runnning Ideablade Version: 3.6.4.1 and getting the error:

{"Unable to construct in-memory query expression - expression is more than 8000 chars long. Please try to restrict the size of this query expression"}

 
The error is happening with only some of the queries irrespective of query length. We manage to run a query with over 100, 000 character with no problem where as other queries with abt 30000 characters return with the above mentioned error.
 
There is no problem with the queries as these queries run with SQL Management studio and return the correct data.
 
Can you please let us know what causes this error and if there is a fix for this?
 
Thanks
Nitin
 
 
]]> Sun, 09 Oct 2011 17:32:17 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2996&PID=11774#11774