biggest number

[Dani R]

in a table i have id number (serial) . how can i rub i script to get the biggest number (the last)?

it is for a portal that i will have id 3,7,10,13,34 so i can get the number 34 .

thank you all

dani

[mr_vodka]

See here

http://fmforums.com/forum/showtopic.php?tid/202667/post/322478

You can also use Last ()

[Dani R]

i did try what you suggest. i upload a image of the script .

but i do not get the biggest number. why?

[bcooney]

Dani, it seems that you are looking to capture the largest ID in a found set in the same table (not a child table).

Just use a summary field that = Max (ID). No script necessary. Remember, though that summary fields are dependent on found set, but given your script, it seems that you are looking for the highest ID in a found set.

[Dani R]

the table is a child table of history of a item . i need to find the biggest number for the history of the item.

[mr_vodka]

Capture the Max PRIOR to your GTRR.

[Søren Dyhr]

Depending of the use obviously, would I consider an extra TO related similar but with the reverse sortorder of the creations, a GTRR would always land in that particular record if the cursor is taken away from a field in the portal ... Commit -> Gtrr does this, provided this utility relation is used instead!

I have during the course of versions been dissuaded from extensive use of Last( ... but things might have changed?

--sd