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

Haris Kurtagic haris at sl-king.com
Wed Mar 10 16:47:21 EST 2010

You were right, King.Oracle didn't supported distinct.

I just released 0.8.15 version which supports distinct.


On Wed, Mar 10, 2010 at 9:14 PM, Benoit Begin <bbegin at geomapgis.ca> wrote:

> 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();
> mgAggrOption.SelectDistinct(true);
> mgAggrOption.AddFeatureProperty("MyColumn");
> 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.
> Thanks.
> --
> 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.
> _______________________________________________
> fdo-users mailing list
> fdo-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/fdo-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/fdo-users/attachments/20100310/d1a3301e/attachment.html

More information about the fdo-users mailing list