[fdo-trac] #752: KingOracle does not support double quotes

FDO trac_fdo at osgeo.org
Wed Mar 16 06:54:25 EDT 2011


#752: KingOracle does not support double quotes
-----------------------------------+----------------------------------------
   Reporter:  bscott               |       Owner:  haris
       Type:  defect               |      Status:  new  
   Priority:  major                |   Milestone:  3.6.0
  Component:  KingOracle Provider  |     Version:  3.5.0
   Severity:  3                    |    Keywords:       
External_id:                       |  
-----------------------------------+----------------------------------------
 Let's say i want to simulate this kind of query

 Select MYCOMMENT AS "COMMENT" from MyTable
 We need to put some double quotes around COMMENT as it is a reserved word
 in Oracle

 With the FDO API we would do this
 queryOptions.AddComputedProperty("\"COMMENT\"", "MYCOMMENT");

 This will failed later on SelectFeatures or SelectAggregate
 An exception occurred in FDO component.Unknown Property Name

 This works fine with the Autodesk.Oracle Provider

 Also I think we should be able to use SelectFeatures as it is not really
 an aggregate query

 Bruno scott

-- 
Ticket URL: <http://trac.osgeo.org/fdo/ticket/752>
FDO <http://fdo.osgeo.org/>
Feature Data Objects


More information about the fdo-trac mailing list