[fdo-users] Select "TOP" or "rownum < "

Jackie Ng jumpinjackie at gmail.com
Thu Nov 19 09:10:40 EST 2009

Shouldn't this work through raw SQL? Most RDBMS FDO providers should support
raw SQL.

This would be a good extension for the FdoISelect interface. Something like
a SetLimit()/GetLimit() property, with matching capabilities to determine if
this property is usable.

- Jackie

Crispin_at_1Spatial wrote:
> Hi,
> I cannot apply a "rownum < 100" to KingOracle (well, not through MapGuide)
> as it is interpreted a column name.
> Any suggestions as how to do this?  I want the query to be optimised at
> the database and not have to truncate a stream of features with my own
> count?
> Because of the different interpretations "SELECT TOP" in SQLServer and
> "rownum < " in Oracle it seems like an obvious candidate for an FDO
> function/expression (not sure which terminology is right here) that can be
> published by providers and interpreted appropriately.
>  Crispin

View this message in context: http://n2.nabble.com/Select-TOP-or-rownum-tp4031693p4031997.html
Sent from the FDO Users mailing list archive at Nabble.com.

More information about the fdo-users mailing list