[fdo-users] King.Oracle 0.8.14 and SelectDistinct(true) in Mapguide 2.1

Benoit Begin bbegin at geomapgis.ca
Wed Mar 10 15:14:09 EST 2010

I'm experiencing some issues with the Distinct option using the
SelectAggregate function. It does not seem to take into account the distinct
property. In the data reader returned to me, I have all of the values,
regardless of if they are different or not. The field I am evaluating is a
standard varchar(3) field.

Here is an exemple of what I'm trying to do...

MgFeatureAggregateOptions mgAggrOption = new MgFeatureAggregateOptions();
MgDataReader mgDataReader = mgFeatureService.SelectAggregate(....)

Is there some workaround to this issue or is it something I might be doing
wrong? I can work around the problem by re-filtering the data manually and
building my list of unique values on my own. It works for my sample data of
22,000 records, though it might prove inefficient for larger datasets.

View this message in context: http://n2.nabble.com/King-Oracle-0-8-14-and-SelectDistinct-true-in-Mapguide-2-1-tp4711979p4711979.html
Sent from the FDO Users mailing list archive at Nabble.com.

More information about the fdo-users mailing list