Opened 13 years ago

#752 new defect

KingOracle does not support double quotes

Reported by: bscott Owned by: haris
Priority: major Milestone: 3.6.0
Component: KingOracle Provider Version: 3.5.0
Severity: 3 Keywords:
Cc: External ID:

Description

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

Change History (0)

Note: See TracTickets for help on using tickets.