mORMot Open Source

Jules Winnfield

Member

Registered: 2011-11-28

Posts: 1

Sorting and Filtering TSQLRecord

There is TSQLRecord with two fields Animal: String and Count: Integer. After CreateAndFillPrepare I got at least 5 rows in this record. How can I sort them by field "Count"? And how can I Filter them so that stay rows only with Field "Count">5? Is it possible?

Thanks...

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,659

Website

Re: Sorting and Filtering TSQLRecord

You can add a "where" clause to CreateAndFillPrepare.

Please download and read the corresponding part of the documentation (especially SAD document).
See http://synopse.info/fossil/wiki?name=Downloads

You'll find there how to make requests with our framework (there are several ways).