nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

out-of-box way to find the maximum value of a field in a table?

SuiHuang

Hi Everybody:

In ArcObjects 10 code, I want to query the maximum value of a field of a table in GeoDatabase (file geodatabase for now). The available method currently in my mind is to loop through every record and judge the maximum value in the code. Is there better way to make it more convenient? Is there any interface to let me do aggregate search (MAX, MIN, Count, etc.)?
Thank you!

タグ付きの投稿をもっと見る

Accepted answers

Hornbydd

Sui,

You want to be using the IDataStatistics Interface.

Duncan

All comments

Hornbydd

Sui,

You want to be using the IDataStatistics Interface.

Duncan

SuiHuang

Sui,

You want to be using the IDataStatistics Interface.

Duncan

Thank you!

RichWawrzonek

Sui- I noticed you have never accepted an answer to your posted questions. I'm not in the hunt for any point awards, but I'm sure there are many here who would appreciate some recognition for using their valuable time to help you.

MichaelRobb

IDataStatistics is one way or
One could also simply sort (using decending) the field and grab the first row value.

SuiHuang

Sui- I noticed you have never accepted an answer to your posted questions. I'm not in the hunt for any point awards, but I'm sure there are many here who would appreciate some recognition for using their valuable time to help you.

Hi richwawr:

Thank you for letting me know. Before I just clicked the upper arrow the increase the count of answers and through that's the process of accepting answer. Now I notice that there is a tick underneath for me to click and accept. I will accept the answers in my previous questions. Thank you again for letting me know.

Sui

会話に参加する

サインインしたメンバーは投稿、更新のフォローなどができます。初めてですか？無料アカウントを登録してください。

クイックリンク

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.