mORMot Open Source

ManUn

Member

Registered: 2013-02-04

Posts: 22

Limit number o Records

Hi, is there a way to limit the number of records that is passed from the server to the client, even if the search retrieves more than that limit?
I'm using the ORM with SQlite and HttpServer.

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,659

Website

Re: Limit number o Records

You have a LIMIT clause at the SQL level.

If I understand correctly, you want it at ORM level?
Just add 'LIMIT ...' in the WHERE clause (even if it is void).