mORMot Open Source

StxLog

Member

From: France

Registered: 2015-09-14

Posts: 58

SOLVED - max() min()...

Hi!

Maybe I am just stupid or i read badly, but i can't find any example where the SQL MAX() or MIN() are used, even if AB is quickly talking about it in here.

My client is a TSQLHttpClientRequest, and i'd like to know the biggest value from a given column client side. How can I do that the easiest way please?

Thanks in advance, and sorry for my bad english.

Last edited by StxLog (2015-09-30 12:50:35)

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,659

Website

Re: SOLVED - max() min()...

You could use 'MAX(aFieldName)' as FieldName parameter of the TSQLRest.OneFieldValue() method, for instance.

Up to now, only MAX() was working.
I've fixed it via http://synopse.info/fossil/info/6b813a3d3e

Hope it helps.

StxLog

Member

From: France

Registered: 2015-09-14

Posts: 58

Re: SOLVED - max() min()...

Thank you for taking the time to answer such question!

Have a nice day and keep up the great work !

Last edited by StxLog (2015-09-30 12:51:10)