When I used Datatable.Expression = [1874 characters] BUT it stops reading/running..
Is there a Max Length on this? How can I make my very long "expression string" works?
Expression is a string so I doubt there's a real limit. You might have a bug in the text/expression you are using. But really, if your expression is that long, you might want to rethink what you're doing. I, for one, would not want to maintain or deal with
an expression that long; what a nightmare that would be.
But it seems there is a limitation.. I understand that the expression is too long but the design of this process is dynamic and that expression is not possible.. the expression is just like this btw... "1 + 2 + 3 + 4...." (up 1800+ characters)...
Do you propose other "expression" way or something?
If possible, you might do some of the processing in a stored procedure perhaps. Or perhaps use LINQ to facilitate maintenance. It's hard to say wihtout knowing more.
search videos at Google with debug visual studio 2010
B-) Please help me by completing my school survey about computer programmers on my website. Thank you!!! Gerry Lowry +1 705-429-7550 wasaga beach, ontario, canada
Kurai
Member
233 Points
184 Posts
DataTable Expression Max Length?
Nov 05, 2012 04:26 AM|LINK
Hi Everyone,
When I used Datatable.Expression = [1874 characters] BUT it stops reading/running..
Is there a Max Length on this? How can I make my very long "expression string" works?
Thanks...
Expression length DataTable max
MetalAsp.Net
All-Star
112151 Points
18246 Posts
Moderator
Re: DataTable Expression Max Length?
Nov 05, 2012 05:51 AM|LINK
Kurai
Member
233 Points
184 Posts
Re: DataTable Expression Max Length?
Nov 05, 2012 07:20 AM|LINK
Hi MetalAsp.Net,
Thanks for the reply...
But it seems there is a limitation.. I understand that the expression is too long but the design of this process is dynamic and that expression is not possible.. the expression is just like this btw... "1 + 2 + 3 + 4...." (up 1800+ characters)...
Do you propose other "expression" way or something?
Thanks..
MetalAsp.Net
All-Star
112151 Points
18246 Posts
Moderator
Re: DataTable Expression Max Length?
Nov 05, 2012 10:14 AM|LINK
gerrylowry
All-Star
20513 Points
5712 Posts
Re: DataTable Expression Max Length?
Nov 05, 2012 01:15 PM|LINK
@ Kurai
likely, you'll need to use the debugger* at least to provide your peers here with better information.
with the minimal information that you've provided, it's difficult to help you; for example, you've not shown us the relevant snippets of your code.
what is it ????????
what about 1873, 1872, ... and lower?
g.
* walking your code with your debugger:
video, c. 8 minutes: http://msdn.microsoft.com/en-ca/vstudio/ee672313.aspx
"How Do I: Step with The Debugger in Visual Studio?"
Debugging: http://lmgtfy.com/?q=debug+visual+studio+2010
example: http://www.codeproject.com/KB/cs/MasteringInDebugging.aspx
videos: http://www.youtube.com/watch?v=z5gBIizwsY0
search videos at Google with debug visual studio 2010