[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