[fdo-users] ISelect and ISQLCommand Usage

[Traian Stanev]

In theory, you should be able to query only certain columns using an FdoISelect. There is a GetPropertyNames() call on the FdoISelect object. It returns a collection of property names that you can add to. If the collection is empty, all columns are returned, otherwise, the specified columns are returned.

However, I bet the implementation of this varies across providers.

Traian




> -----Original Message-----
> From: fdo-users-bounces at lists.osgeo.org [mailto:fdo-users-
> bounces at lists.osgeo.org] On Behalf Of Crispin @ 1Spatial
> Sent: Friday, January 04, 2008 11:50 AM
> To: fdo-users at lists.osgeo.org
> Subject: [fdo-users] ISelect and ISQLCommand Usage
>
>
> Hi,
>
> Having, ahem, mastered a .net application with ISelect and passing in a
> spatial filter I started to look at optimising the data traffic (as per
> similar to http://trac.osgeo.org/mapguide/ticket/272)
>
> I want to query only certain columns... so being able to specify in
> ISQLCommand is great but I loose the generic ability to apply a spatial
> filter using the .filter property and have to create different SQL for
> every
> provider, thus loosing the power of FDO!
>
> So can I
>
>  a) Only query certain columns using ISelect ?
>
> or
>
>  b) Apply a generic spatial filter method using ISQLCommand ?
>
>
> Thanks in advance,
>
>  Crispin
>
> --
> View this message in context: http://www.nabble.com/ISelect-and-
> ISQLCommand-Usage-tp14618931s18162p14618931.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