[fdo-users] ISelect and ISQLCommand Usage
traian.stanev at autodesk.com
Fri Jan 4 17:37:17 EST 2008
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.
> -----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
> 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
> provider, thus loosing the power of FDO!
> So can I
> a) Only query certain columns using ISelect ?
> b) Apply a generic spatial filter method using ISQLCommand ?
> Thanks in advance,
> View this message in context: http://www.nabble.com/ISelect-and-
> Sent from the fdo-users mailing list archive at Nabble.com.
> fdo-users mailing list
> fdo-users at lists.osgeo.org
More information about the fdo-users