QuoteReplyTopic: “Allow Column Selection” doesnt seem to quote fields 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"...'
'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 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?
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum