Latest Contributions by DuncanHornby

v10 should see them. Was the toolbox a stand alone tbx file or a toolbox inside a geodatabase? If it is a tbx file is it actually in the same folder, can you see it in Windows explorer? ... View more

James, I think it's a geoprocessing memory leak issue. I have had all sorts of problems when I do lots of looping in Python using the geoprocessor.  There did not seem to be solution. The only improvement I could make was not to have any of the data in a personal geodatabase but as Shapefiles. This was especially true when doing lots of selections. Ultimately the code would crash as it ran out of memory so I had to run it in batches with me periodically closing down ArcMap. Rediculous really, you would have though they had fixed all that as it's been a continuing problem from 9.3. Duncan ... View more

Alex, May be I'm misunderstanding the models logic but I have a question? I'm assuming inputs Address2 and Select Features:Address are the same layer (may be a point layer)? You do a query selection on this and use this selection to select the parcels. Then you use an iterator which is grouping by recnum. Is recnum unique within the selection? If so then with each iteration you are writing recnum to the selection in the address layer and this I guessing is overwriting the value again? If this model is allowed to run to completion is the value written into Adress the very last recnum? Duncan ... View more

Linda, I had a play with the ITableWindow2 Interface in VBA and found using your code I too could crash ArcMap.  I then played around with the properties and found this combination to work: Public Sub x()     Dim pMXDOC As IMxDocument     Set pMXDOC = ThisDocument     Dim pmap As IMap     Set pmap = pMXDOC.FocusMap     Dim pl As ILayer     Set pl = pmap.Layer(0)     Dim pTW2 As ITableWindow2     Set pTW2 = New TableWindow     With pTW2         Set .Application = Application         Set .Layer = pl         .ShowAliasNamesInColumnHeadings = True         .TableSelectionAction = esriSelectFeatures         .Show True         .ShowSelected = True     End With End Sub I changed the selectionAction  but note I show the TableWindow THEN I show the selected... Duncan ... View more

Robin, You could get into using the GeoProcessor and calling existing tools through the Execute method, this avoids having to know every nuance of ArcObjects. If you want to use the ArcObjects approach then in VBA all you need to do to create a PERSONAL geodatabase is this: Public Sub test()     Dim pWSF As IWorkspaceFactory     Set pWSF = New AccessWorkspaceFactory     Dim pWSN As IWorkspaceName     Set pWSN = pWSF.Create("C:\temp", "pGDB_Test", Nothing, 0) End Sub Duncan ... View more

Jenny, The only thing I spotted with your code is this line: Set EditorEvents = Application.FindExtensionByName("ESRI Object Editor") All the code samples in help use: Dim pID as New UID pID = "esriEditor.Editor" Set m_pEditor = Application.FindExtensionByCLSID(pID) Set EditEvents = m_pEditor Duncan ... View more

You want to use the Interface IStandaloneTableCollection. ... View more

A work around to this problem is this: maintain your data in separate geodatabases or if you are using shapefiles separate folders then you are only ever editing a single workspace. Clunky but this stops you messing up your data. ... View more

Just want to add my "2 cents" to this thread. I have spent the last 2 hours trying to run a spatial join of points to points using the closest match option. Every time it crashed. I tried moving the data to a file geodatabase, to shapefiles, stripped down the fields to the bare minimum, removed domains, you name it I did it. I then asked someone in my office if they could run it to rule out this stupid roaming profile setup we have on our network. Hey presto it worked! AHHH! Anyway the only difference I noticed was that her geoprocessing tool ran as back ground task. I had turned that off along time ago as I think it's pointless and I find the dialog helpful to watch whats going on. So I out of desperation I turned this back on and it worked.  Seriously cheesed off about this... ... View more

It would be great if there was some method on arcpy that purged the memory even if it had a performance hit. If I'm doing large data crunching I'm not going to worry over a few seconds if the data crunching takes several hours.  I was imagining something like: arcpy.ClearMemory Then behind the scenes this would release cursors and objects that are out of scope etc. ... View more

Looking at your code it looks like you are not giving the full path to your file geodatabase.  You set the string targetworkspacepath to simply "melaka.gdb" but where is it? Is it c:\temp or c:\gis\db? I think you need to provide the full path something like c:\temp\melaka.gdb Duncan ... View more

Aaron, I dabbled in developing a geoprocessing tool a few years ago in 9.3 as a way of teaching myself.  Didn't get very far! I have some vague memory that I had to "pack" my parameters. Look at the IGPUtilities interface and PackGPValue method? Just an idea... Duncan ... View more

Michelle, My toolbox in my opinion is not a good place to store anything as it's in my documents which is a directory on the computer so if that blows up you loose the lot! I would recommend you create a folder in the projects folder and call it something simple like GeoProcessing. Then unzip the zip folder into it and you will have your toolbox and the python script in it.  You can then use the catalog window in arcmap to navigate to that folder then you'll see the toolbox, navigate into that for the script tool and at that point you will probably want to go into it properties to ensure the python script it's point to is the one in that folder and not my computer! Duncan ... View more

Michelle, It looks like you got confused and removed the wrong parameter from the wrong thing. I have corrected this and uploaded the script and toolbox in a single zip file. You may need to repoint the toolbox to point to the python script as it may have picked up the location where I stored it on my machine. As you'll see it's not your script that was wrong but the toolbox interface. You were introducing an 8th input which was never used, but your python script only had 7 parameters and it was looking at the table when it really wanted your field. Duncan ... View more

Michelle, Well I think your problem is that your Script is taking 7 inputs but your toolbox interface is asking for 8! You need to set select SRF grid to be of type FeatureLayer and have it loaded in arcmap so you can select it from the drop down. Delete your 7th parameter which is asking for a table, you don't need this as this is output table from your sql query. Finally for your input Selected Join Field "CellID1" set Obtained from to nothing and set it's default value to CellID1. Duncan ... View more