How do i find the maximum value in a found set ?

[Steven Cappiello]

Hi,

I want to find the Maximum Record ID in my found set so that I can alert my user that there have been new records added to the database by showing the records through a self-join that have a larger Record ID.

Max( ) seems to work on the entire database, and not just the found set.

Can someone make a recommendation?

[Søren Dyhr]

Take the Tailrecursion CF from here:

http://www.filemakerpros.com/GetNthRecordTAIL.zip

...and this CF:

http://www.briandunning.com/cf/757

...and make a combination in the vicinity of what the template here shows!

--sd

theMaxedout.zip

[comment]

A summary field can do that. If you need the result as a calculation, in order to base a relationship upon it, you can use the GetSummary() function.

[Vaughan]

"I want to find the Maximum Record ID"

If the Record ID is auto-entered, and they are sequential, then the "maximum" record ID will be the last record when the found set is unsorted.

Or am I missing something?

[Steven Cappiello]

Thanks for the help!!!