Re: [Modeling-users] Limit

[Jerome K. <Jer...@fi...>]

On Fri, Feb 21, 2003 at 04:24:53PM +0100, Sebastien Bigaret wrote:

One of my favorite game, awking dead thread :) 

Apologize for this long time answer. 


> > Limit to a fixed maximum number? Don't think you can (for Sebastien to
> > confirm) unless there is hidden support for specifying TOP N on SELECTs
> > (which i think is not standard SQL?). And, how would you get the next batch
> > then?
> 
>   Sorry soif, Mario's right... there's currently no way to limit or batch
>   the fetch. However EditingContext.objectsCountWithFetchSpecification()
>   will tell you how many objects (in fact, the upper limit) you'll get if
>   you send the same parameters to objectsWithFetchSpecification().

Yes in fact, i ever know this. 
 
>   More on this: if someone knows some standard SQL for doing this, I'm
>   interested, it would for sure make the release-time for such a feature,
>   if requested, closer than it actually is.


After some googling, i found nothing. In fact 'LIMIT' is a SQL92
keyword, but i found nowhere the SQL92 def of this :( , anyways i
use it on a couple of DB before and i 've never see something that
doesn't support it. 


Bye Bye .. :) 

==