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

[Crispin_at_1Spatial]

It may work through FDO direct SQL .  It is a MapGuide layer that I am trying
to "protect".

Though something like a GetLimit(1000) capabilities that is exposed and
translated to native SQL would be perfect I am not sure at what provider
level this would need to be created at to enable me to apply this on a
MapGuide layer level.



Jackie Ng wrote:
> 
> 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-tp4031693p4033042.html
Sent from the FDO Users mailing list archive at Nabble.com.