Latest Contributions by FreddieGibson

Do you have access to your My.Esri account? You should be able to download it from there. ... View more

I've put together a screenshot from the attached EULA. This legal notice is installed in the legal subfolder of the ArcGIS Runtime SDK installation folder. ... View more

I would expect the second issue you're seeing because the creation of the cursor has no effect on the source data. I would also assume that the count you're getting for the first cursor is wrong unless your data happens to match the filter in the cursor. Have you tried creating a feature layer against the data using the filters you're providing to the cursor? Otherwise you can iterate through the cursor and get the count prior to looping through it again. I wrote up examples of this below, but note I didn't test either of these. They're just how I'm thinking this would work. Option A - Get the count using a table view or feature layer ufields = ("STREAM_CODE","SPECSTR","TYPE","MEAS","PROB") ufilter = "TYPE = 'MIDSP'" with arcpy.da.UpdateCursor(inPtMeasureTbl, ufields, ufilter) as ucursor:     utview = arcpy.management.MakeTableView(inPtMeasureTbl, "utable", ufilter)     ucount = int(arcpy.management.GetCount(uview).getOutput(0))     for urow in ucursor:         cfields = ("STREAM_CODE","SPECLS","F_MEAS","T_MEAS")         cfilter =  "STREAM_CODE='{}' and F_MEAS <= {:.6f} and T_MEAS >= {:.6f}".format(*[urow[0], urow[3], urow[3]])         with arcpy.da.SearchCursor(inEventTbl, cfields, cfilter) as ccursor:             ctview = arcpy.management.MakeTableView(inEventTbl, "ctable", cfilter)             ccount = int(arcpy.management.GetCount(ctview).getOutput(0))             print("Line Events Count: {0}".format(count))                         for crow in ccursor:                 print("Found event: {} Specstr: {} Measures: {:.6f} , {:.6f}".format(*row)) Option B - Get the count from the cursor ufields = ("STREAM_CODE","SPECSTR","TYPE","MEAS","PROB") ufilter = "TYPE = 'MIDSP'" with arcpy.da.UpdateCursor(inPtMeasureTbl, ufields, ufilter) as ucursor:     ucount = 0     for _ in ucursor:         ucount += 1        ucursor.reset()         for urow in ucursor:         cfields = ("STREAM_CODE","SPECLS","F_MEAS","T_MEAS")         cfilter =  "STREAM_CODE='{}' and F_MEAS <= {:.6f} and T_MEAS >= {:.6f}".format(*[urow[0], urow[3], urow[3]])         with arcpy.da.SearchCursor(inEventTbl, cfields, cfilter) as ccursor:             ccount = 0             for _ in ccursor:                 ccount += 1                            ccursor.reset()                         print("Line Events Count: {0}".format(count))                         for crow in ccursor:                 print("Found event: {} Specstr: {} Measures: {:.6f} , {:.6f}".format(*row)) ... View more

The gp results shouldn't be coming back as null. I took a few minutes to write up the attached sample. Because you're using the gp tools I also used the gp tools instead of executing this entire workflow in ArcObjects. I've also pasted the code to create the join below. There is also a second sample in the attachment that shows how to commit the join by calling the copy features tool. using ESRI.ArcGIS.Carto; using ESRI.ArcGIS.DataManagementTools; using ESRI.ArcGIS.Geodatabase; using ESRI.ArcGIS.Geoprocessing; using ESRI.ArcGIS.Geoprocessor; using System; using System.IO; namespace ArcMapAddin {     public class AddJoinLayerToMap : ESRI.ArcGIS.Desktop.AddIns.Button     {         private static readonly string m_srcPath = Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().Location);         private static readonly string m_gdbPath = Path.Combine(m_srcPath, @"data\data.gdb");         private const string m_fclName = "StateGeom";         private const string m_tblName = "StateTabl";         private const string m_joinFld = "STATE_ABBR";         protected override void OnClick()         {             var fws = OpenWorkspace(m_gdbPath) as IFeatureWorkspace;             var fcl = fws.OpenFeatureClass(m_fclName);             var tab = fws.OpenTable(m_tblName);             var lyr = new FeatureLayerClass { FeatureClass = fcl, Name = fcl.AliasName, Visible = true };             var gp = new Geoprocessor { OverwriteOutput = true, AddOutputsToMap = false };             try             {                 var tool = new AddJoin { in_layer_or_view = lyr, in_field = m_joinFld, join_table = tab, join_field = m_joinFld, join_type = "KEEP_COMMON" };                 var result = gp.Execute(tool, null) as IGeoProcessorResult2;                 if (result.Status == ESRI.ArcGIS.esriSystem.esriJobStatus.esriJobSucceeded)                     ArcMap.Document.FocusMap.AddLayer(lyr);             }             catch (Exception ex)             {                 System.Diagnostics.Debug.WriteLine(ex.Message);             }         }         private static IWorkspace OpenWorkspace(string gdbPath)         {             var ftype = Type.GetTypeFromProgID("esriDataSourcesGDB.FileGdbWorkspaceFactory");             var wsf = Activator.CreateInstance(ftype) as IWorkspaceFactory;             return wsf.OpenFromFile(gdbPath, 0);         }     } } ... View more

I think you may need to log a support ticket to see if this is by design. I would assume that at the database level this information wouldn't be case sensitive and the tool would think that you're trying to name the field to what it's already named. To get around it you could just add an extra character to the field and then change it back to the original word in the case you're needing. ... View more