http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce Classic : “Allow Column Selection” doesnt seem to quote fields Wed, 10 Jun 2026 05:54:45 -700 Tue, 27 Jul 2010 19:06:08 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=1955 http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ http://www.ideablade.com/forum/forum_posts.asp?TID=1955&PID=7839#7839 Author: agrogers
Subject: 1955
Posted: 27-Jul-2010 at 7:06pm

Thanks Ting.  Yes, i received that update.  We had managed to work around it while we were waiting by using Views which, once we got past the updatable problem, look like they might be a better solution.  However i have got my guys looking at the patch.  Will that be included in future DevForce releases?
]]> Tue, 27 Jul 2010 19:06:08 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1955&PID=7839#7839 http://www.ideablade.com/forum/forum_posts.asp?TID=1955&PID=7687#7687 Author: ting
Subject: 1955
Posted: 19-Jul-2010 at 5:37pm

Sorry for the delay.  Support should have sent you a build that fixes this.

]]> Mon, 19 Jul 2010 17:37:04 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1955&PID=7687#7687 http://www.ideablade.com/forum/forum_posts.asp?TID=1955&PID=7619#7619 Author: agrogers
Subject: 1955
Posted: 13-Jul-2010 at 6:25pm

Hi guys.  Still looking forward to an answer on this one.
Thanks
Andrew
]]> Tue, 13 Jul 2010 18:25:55 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1955&PID=7619#7619 http://www.ideablade.com/forum/forum_posts.asp?TID=1955&PID=7578#7578 Author: agrogers
Subject: 1955
Posted: 09-Jul-2010 at 2:02am

We have turned “Allow Column Selection” on in order to return a reduced number of columns from a table.  That works fine except that DevForce doesnt quote or bracket the column names.  So a query that should look like

'SELECT "Name1", "Surname" FROM "People"...'

looks like

'SELECT Name1, Surname FROM "People"...'  - the quotes are missing from the SELECT part of the query

Of course this causes problems with some column names.  Everything else in the query gets quoted except this.  What have we done wrong to cause this?

Thanks
]]> Fri, 09 Jul 2010 02:02:38 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1955&PID=7578#7578