Find Max Value

johndim

i have a table and i want to get the max value of a field (type integer) .
any help ?

ara3n

Create a key for that field (integer). Set currentkey on that new key. and do Find('+').

kriki

2 possibilities.

1) you read every record in the table and keep the biggest one in memory, but depending on the number of records, it can take a lot of time to find it.

2) put a new index on it and when you need it do:
MyRecord.RESET;
MyRecord.SETCURRENTKEY("My Integer");
IF MyRecord.FIND('+') THEN
MESSAGE('The biggest value is %1',MyRecord."My Integer");
This option slows down a little on writing in that table but reading is lightning fast.

johndim

Thank you very much both