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

Crispin_at_1Spatial crispin.hoult at 1spatial.com
Thu Nov 19 08:10:15 EST 2009


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.


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

More information about the fdo-users mailing list