Latest Contributions by BrianLeroux

Steve- I have not had a minute to work on this. The new spatial query in 1700 workds great with any lines or polygons. I wish I had the code to incoporate into my add-ins. Anyway, if you could share the vb.net version of the code Darryl supplied it would be greatly appreciated and save me some time. Thanks! ... View more

It can be done by creating an add-in (vb.net). I have done so but the code is specific to my application so it will not be useful to share the entire add in. If you would like to see some of the code I would be happy to share. ... View more

Works for me. You may weant to provide additional info to your issue so someone will be able to properly assist you. ... View more

I could not find anything in the SDK either. I think I will try to fumble through your second option to see what i can come up with. Thanks! ... View more

I can't get this layer by query code working. Any help is appreciated. Dim points As Table = tvwMapItems.SelectedNode.Tag         Dim poly As Table = tvwMapItems2.SelectedNode.Tag         'Create a List to store ObjectID's         Dim objectIDList As List(Of Integer) = New List(Of Integer)()         'Loop over each  area and perform a spatial query to find points         For Each polyArea As Row In poly.GetRows()             Dim polyAreaShape As Geometry = polyArea.Geometry             Dim foundPoints As RowCollection = points.Search(New Filter(polyAreaShape, FilterSearchOptions.Intersects))             For Each rw As Row In foundPoints                 objectIDList.Add(rw.ObjectID)             Next         Next         ' create the table binding adapter and fill it         Dim tableBindingAdapter As TableBindingAdapter = New TableBindingAdapter(points)         tableBindingAdapter.UseColumnAliasNames = True         tableBindingAdapter.UseCodedValueDomains = True         tableBindingAdapter.Fill(objectIDList.ToArray())         ' display the results         Dim resultsForm As QueryResultsForm = New QueryResultsForm(tableBindingAdapter)         resultsForm.ShowDialog() ... View more

I have never had a chance to try this but you may want to look into it. http://www.codeproject.com/KB/grid/multicolumn_sort.aspx ... View more

Donna, The file number is text as it may contain letters. We just call it a number internally as it has always been called that. I am using a variable in the search and can do a UCase there no problem. My issue is that i need to convert the data i am searching through to UCase also and can not find a way to do that. The reason i need to convert is because this tool I am devoloping will not just search my file numbers but any field from any feature I have selected and that may include different cases for text fields. looking at datagridview.fill I do not see any way to specify the columns. I would actually like to do this as well and was planning on looking into it further. I will let you know what i find. ... View more

So my next problems with my Search Add-in.. 1) The search is case sensitive and I would like it not to be. I was going to use UCase on the search string and the column data. However, since I am using table.search there is no select statement to use UCase on the column I am searching. 2) I would like to use LIKE in the where clause for my columns formatted as numbers. That would mean i need to CAST them as a string. As in the case of the issue abouve, since there is no select statement I can't perform a CAST on the field I am searching. Any ideas are appreciated. ... View more

There is a tool called Export Feature Attribute to ASCII that I just tried for the first time a moment ago.  You might look at that, and then see if you can figure out a way to automate importing that into access.  Certainly you could import it manually... Good Luck! Joe- Thanks mentioning that tool. I was able to develop a workflow as follows. Import policies to my DB and have a query run that selects only the new policies. I have a model that uses that query to geocode and return an ASCII file to a specific location. I then import the ASCII file into DB and a query appends the new records to my previously geocoded policies. There are a few manual steps but better than geocoding hundreds of thousands of records monthly. I may be able to even update this weekly.. Thanks again!! ... View more

Donna - Good news. It did actually work. I had the old add-in stuck in cache and my updated code didn't go through.  Thanks for your help.. searchCriteria.WhereClause = "File_Numbe LIKE'%" & SrchTxt & "%'" Try     Dim rows As RowCollection = layer.Table.Search(searchCriteria) ... View more

Donna- That did not work for me. It allows me to search for an exact match put does not work for a partila match. ie- I can search for 1234 and find the file but if i try 12 it does not find 1234. Thanks. Brian ... View more

Thanks Joe. I probably could have worder that better. I will keep digging to see what i can come up with. ... View more

Joe- That does help a little bit. I already have an odbc connection to the access database. I actually use it in a model to geocode the addresses and output to a file geodatabase. I can't figure out how to geocode back to teh access database. Is there any documentation on that? Does it matter that I am using an access 2007 accdb? ... View more