DevForce Community Forum : trim or left on char fields http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : trim or left on char fields Mon, 13 Apr 2026 20:32:30 -700 Wed, 18 May 2011 17:46:46 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=2695 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ trim or left on char fields : Hi Kurt,Canonical functions... http://www.ideablade.com/forum/forum_posts.asp?TID=2695&PID=10751#10751 Author: kimj
Subject: 2695
Posted: 18-May-2011 at 5:46pm

Hi Kurt,
 
Canonical functions like Trim and LTrim are supported today when using Entity SQL in DevForce.  The PassthruEsqlQuery is used for ESQL queries in DevForce.   You can find more information here - http://drc.ideablade.com/xwiki/bin/view/Documentation/passthruesql-query
 
The "AfterGet" property interceptor might be a better alternative for the char fields.  With an AfterGet interceptor you can modify the value before it's returned from a property getter, so you could use this to strip off spaces.  It's true that the queried data would still have spaces when returned from the EntityServer, but since results are compressed before sending to the client the extra spaces probably don't cause a significant increase in payload size.  If you want more information on property interceptors this is a good place to start - http://drc.ideablade.com/xwiki/bin/view/Documentation/attribute-interception. 
 
 
]]> Wed, 18 May 2011 17:46:46 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2695&PID=10751#10751 trim or left on char fields : Any idea on when we might... http://www.ideablade.com/forum/forum_posts.asp?TID=2695&PID=10740#10740 Author: kpinniger
Subject: 2695
Posted: 18-May-2011 at 6:20am

Any idea on when we might support EF 4 ability to do a left or trim on char columns...
 
We have values in our legacy customer databases like this for a value,
 
“AP                    ”
 
and it is a char(60).  We cannot change customers data and we cannot change customers column types, so we would like to be able to use EF 4 trim or ltrim.  So when we retrieve data we need to be able to trim off the padded spaces.
 
Thanks,
Kurt Pinniger
CDC Software
 
 
]]> Wed, 18 May 2011 06:20:45 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2695&PID=10740#10740