Latest Contributions by Corbinde_Bruin

Hi all, I'm new to SQL statements and especially within ArcGIS. I'm programming an addin against a file geodatabase in in Desktop 10.1 and I'm getting this error: An invalid SQL statement was used. [SELECT FeatureClassAlias FROM tblFeatureClasses WHERE IsSearchable = 'Y' ORDER BY SortSequence] It works if I take out the ORDER BY SortSequence part, but it obviously doesn't sort at all. I've looked at all the ESRI references on SQL with File geodatabases and can't see my error. It says field names may be delimited by quotes, but that hasn't helped. It also says that ORDER BY won't work if I'm searching in all fields with SELECT *, but that shouldn't be my problem. An invalid SQL statement was used. [SELECT "FeatureClassAlias" FROM tblFeatureClasses WHERE "IsSearchable" = 'Y' ORDER BY "SortSequence"] I'd greatly appreciate help with this issue from someone with SQL experience. I'll also post the code if you think it will help. Thank you, cdebruin   Public Sub LoadTblToCbx(inputTable As ITable, inputFieldName As String, cbxInput As System.Windows.Forms.ComboBox)                  ' Create the query filter.         Dim queryFilter As IQueryFilter2 = New QueryFilter          ' Select the fields to be returned         queryFilter.SubFields = inputFieldName          ' Set the filter to return only searchable         queryFilter.WhereClause = """IsSearchable"" = 'Y'"          ' Use the PostfixClause to sort ascending         Dim queryFilterDef As IQueryFilterDefinition2 = CType(queryFilter, IQueryFilterDefinition2)         queryFilterDef.PostfixClause = "ORDER BY ""SortSequence"""          ' Output the returned feature class name.         Dim fieldIndex As Integer = inputTable.FindField(inputFieldName)         Dim cursor As ICursor = inputTable.Search(queryFilter, True)         Dim row As IRow = cursor.NextRow()         While Not row Is Nothing             Dim field As String = Convert.ToString(row.Value(fieldIndex))             cbxInput.Items.Add(field)             row = cursor.NextRow()         End While          Marshal.FinalReleaseComObject(cursor)      End Sub ... View more

Hi all, I'm looking to write an Add In in VB .NET that uses the same Address Search as ArcMap's native Find Tool, just tweaked. Is there any way to find some source code for the Find tool? All I'm seeing is the REST endpoint for for the North American Address Locator. I can't find any examples on this. A point in the right direction would be marvelous. Thank you, cdebruin ... View more

Hi all, I'm ultimately looking to create metadata on the field level. ArcCatalog only seems to let you add metadata down to the feature class level. I thought X-Ray for ArcCatalog was my answer, but it doesn't seem to let me change field description and load the XML back into the same geodatabase that I exported the XML from. My understanding is that I can only load an XML with new field descriptions into an empty geodatabase. I would very much like to be proven wrong here if anyone knows differently. If X-Ray for ArcCatalog isn't the answer for this problem, does anyone know of a way to do this? Also, I understand I can just save out an excel file with the descriptions, but I'd ultimately like this data to be stored in the geodatabase itself. Thank you in advance, cdebruin ... View more

Hi all, Somewhere along the line my scroll bars got messed up. Two sets appear at 100% zoom level in IE9. I don't know if I did this accidentally or if this is the natural behavior of the viewer. [ATTACH=CONFIG]17921[/ATTACH] I removed all Widgets and UI compontents to ensure they weren't the cause and the scroll bars were still a problem. Does anyone have an idea of where this would be in code? The index.mxml? I couldn't find it. Thanks, -cdebruin P.S. I see no need to have the default scroll bar on the right-hand side anyway. I just want the application to fill any size screen. Help with getting rid of that scroll bar would be greatly appreciated as well. ... View more