Re: [Modeling-users] Limit

[Mario R. <ma...@ru...>]

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?

You probably have to do a count, and if too many you modify the fetch 
qualifier
to be more restrictive. But, i guess it would be you who would have to 
program
such an algorithm for you app -- would be really nice to have a generic 
declarative
way for this (essentially cursors, or paging, but as far the client app 
code is
concerned, there should be no worries about  maintaining state 
information).

mario

> Hi all :)
>
>
> I'm just wondering how can i limit the result fetched by
> a qualifier. I think i forgot how this work :)
>
>
>
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: SlickEdit Inc. Develop an edge.
> The most comprehensive and flexible code editor you can use.
> Code faster. C/C++, C#, Java, HTML, XML, many more. FREE 30-Day Trial.
> www.slickedit.com/sourceforge
> _______________________________________________
> Modeling-users mailing list
> Mod...@li...
> https://lists.sourceforge.net/lists/listinfo/modeling-users