largest number

[Dani R]

Hi

i have a sql connected to filemaker .

in the table i what to run ש script the will give mק the largest number in a field .

the problem is that i can not add a summery file to the table.

how can i do it?

Thank You Dani

[wonfuji]

Dani

You might sort descending by that number field and go to first record.

You might create a cartesian self-join on the table and create a Max(table_TABLE||x|::number) calc to return max value. (Not certain if that would work to an SQL table).

You could script it: (pseudocode)

Show All

Go First Record

Loop

SetVariable($Max; Case($Max<YourNumberField; YourNumberField; $Max))

GoToNextRecord (Exit After Last)

End Loop

Stephen

[comment]

the problem is that i can not add a summery file to the table.

See if this helps:

http://www.filemaker.com/11help/html/odbc_ess.20.9.html#1027889

[bcooney]

You can add supplemental fields to an ESS, as comment points out, however, what is your goal? I hope that you're not trying to calc a serial ID.