Bug
IQueryFilterDefinition::PostfixClause does not work correctly to ORDER BY when added to a QueryFilter unless edits are saved first.
| Bug ID Number | NIM010578 |
|---|---|
| Submitted | July 25, 2007 |
| Last Modified | June 5, 2024 |
| Applies to | No Product Found |
| Version found | 9.2 |
| Program language | VBA |
| Status | Will Not Be Addressed |
Additional Information
We apologize that we were unable to address this issue within the current product support cycle. If the issue continues to affect your work in a supported release, please contact Technical Support.Workaround
Use IDataStatistics and IStatisticsResults as an alternate way of getting the maximum value from a field:Private Sub TestPostFixClause() Dim pMxDoc As IMxDocument Dim pFL As IFeatureLayer Dim pCur As IFeatureCursor Set pMxDoc = ThisDocument Set pFL = pMxDoc.ActiveView.FocusMap.Layer(0) Set pCur = pFL.Search(Nothing, False) Dim pData As esriGeoDatabase.IDataStatistics Set pData = New esriGeoDatabase.DataStatistics pData.Field = "TestID" Set pData.Cursor = pCur Dim pStatResults As esriSystem.IStatisticsResults Set pStatResults = pData.Statistics Dim MaxObjectID As String MaxObjectID = pStatResults.Maximum MsgBox MaxObjectIDEnd SubSteps to Reproduce
Bug ID: NIM010578
Software:
- No Product Found
Get notified when the status of a bug changes
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App