“Allow Column Selection” doesnt seem to quote fields
Printed From: IdeaBlade
Category: DevForce
Forum Name: DevForce Classic
Forum Discription: For .NET 2.0
URL: http://www.ideablade.com/forum/forum_posts.asp?TID=1955
Printed Date: 16-Apr-2024 at 6:42am
Topic: “Allow Column Selection” doesnt seem to quote fields
Posted By: agrogers
Subject: “Allow Column Selection” doesnt seem to quote fields
Date 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
|
Replies:
Posted By: agrogers
Date Posted: 13-Jul-2010 at 6:25pm
Hi guys. Still looking forward to an answer on this one.
Thanks
Andrew
|
Posted By: ting
Date Posted: 19-Jul-2010 at 5:37pm
|
Sorry for the delay. Support should have sent you a build that fixes this.
|
Posted By: agrogers
Date 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?
|
|